AR Facturación Brasil - Mastersaf
Facturacion de Brasil
Concurrentes y Juegos
Ejecutan un juego de concurrentes llamado MESTRE (Como Nito)
juego: XX AR BR - Programa Mestre de NFFs Automáticas XX_AR_NFF_AUTOMÁTICA XX NFF Automática - Brasil
Compuesto Por:
Etapa 1
XX AR BR - Corrige Aviso de Crédito de Cancelamento na Interface
Solicitudes:
XX AR BR - Corrige Aviso de Crédito de Cancelamento na Interface XXCANCELNFCOR XX_AR_BR_CANCEL_NOTA_FISCAL_PK.CANCEL_NF
Parametros:
Origen da Nota Fiscal: sql =
from apps.ra_batch_sources_all bs,
apps.hr_all_organization_units haou,
apps.hr_organization_information hoi
where bs.status = 'A'
and bs.batch_source_type = 'FOREIGN'
and bs.attribute3 = 'Y'
and bs.org_id = haou.organization_id
and haou.organization_id = hoi.organization_id
and hoi.org_information1 = 'OPERATING_UNIT'
and haou.attribute6 = 'BR'
Etapa 2
Programa Principal de NFF Automática
Solicitudes:
Programa Principal de Factura Automática
RAXMTR
RAXMTR (Producido)
Parametros:
Número de Instancias : Constante = 1
Organización: sql
select meaning from ar_lookups where lookup_type = 'ALL'
Origen de Factura: sql
from apps.ra_batch_sources_all bs,
apps.hr_all_organization_units haou,
apps.hr_organization_information hoi
where bs.status = 'A'
and bs.batch_source_type = 'FOREIGN'
and bs.attribute3 = 'Y'
and bs.org_id = haou.organization_id
and haou.organization_id = hoi.organization_id
and hoi.org_information1 = 'OPERATING_UNIT'
and haou.attribute6 = 'BR'
Nombre Origen Lote: sql
FROM RA_BATCH_SOURCES_ALL
WHERE BATCH_SOURCE_ID = :$FLEX$.RA_AUTOINV_BATCH_SRC_RESTRICTED
AND ROWNUM = 1
Fecha por Defecto: Constante = sysdate
Basar Fecha Vencida en Fecha de Transacción: sql
from fnd_lookups
where lookup_type='YES_NO'
and lookup_code='Y'
tapa 3:
Programa Principal de NFF Automática - Interno
Solicitudes:
Programa Principal de Factura Automática
RAXMTR
Parametros:
Número de Instancias: Constante = 1
Organización: sql
from ar_lookups
where lookup_type = 'ALL'
Origen de Factura: sql
from apps.ra_batch_sources_all bs,
apps.hr_all_organization_units haou,
apps.hr_organization_information hoi
where bs.status = 'A'
and bs.batch_source_type = 'FOREIGN'
and bs.attribute3 = 'N'
and bs.org_id = haou.organization_id
and haou.organization_id = hoi.organization_id
and hoi.org_information1 = 'OPERATING_UNIT'
and haou.attribute6 = 'BR'
Nombre Origen Lote: sql
FROM RA_BATCH_SOURCES_ALL
WHERE BATCH_SOURCE_ID = :$FLEX$.RA_AUTOINV_BATCH_SRC_RESTRICTED
AND ROWNUM = 1
Fecha por Defecto: constante = sysdate
Basar Fecha Vencida en Fecha de Transacción: sql
Select meaning from fnd_lookups where lookup_type='YES_NO' and lookup_code='Y'
Etapa 4
XX AR BR - Processa Alteração NF
Solicitudes:
XX AR BR - Processa Alteração de NF
XXALTNFERRP
XX_AR_BR_ALTER_INVOICE_PK.PROCESSA_CONC
Parametros:
Etapa 5
XX AR BR - Envia à MS Cancelamento de NF
Solicitudes:
XX AR BR - Envia à MS Cancelamento de NF
XXCANCELNFMS
XX_AR_BR_CANCEL_NOTA_FISCAL_PK.ATUALIZA_PREVIOUS_CUSTOMER_TRX
Parametros:
Comentarios
Publicar un comentario