DBA Data[Home] [Help]

APPS.ARP_ETAX_INVAPI_UTIL dependencies on AR_TRX_HEADER_GT

Line 181: FROM AR_TRX_HEADER_GT IL

177: tax_reporting_flag) =
178: (SELECT MAX(document_sub_type),
179: MAX(default_taxation_country),
180: MAX(decode(taxed_upstream_flag,'Y','N','Y'))
181: FROM AR_TRX_HEADER_GT IL
182: WHERE HGT.trx_id = IL.customer_trx_id
183: GROUP BY IL.customer_trx_id);
184:
185: IF PG_DEBUG in ('Y', 'C') THEN

Line 907: AR_TRX_HEADER_GT it,

903: it.trx_header_id,
904: il.trx_line_id,
905: zxe.message_text
906: FROM ZX_ERRORS_GT zxe,
907: AR_TRX_HEADER_GT it,
908: AR_TRX_LINES_GT il
909: WHERE zxe.trx_id = it.customer_trx_id
910: AND NVL(zxe.trx_line_id, -99) =
911: il.customer_trx_line_id (+);