APPS.ZX_ON_FLY_TRX_UPGRADE_AR_PKG dependencies on ZX_LINES

Line 60: INTO ZX_LINES_DET_FACTORS(

56:
57:
58: INSERT ALL
59: WHEN trx_line_type IN ('LINE' ,'CB') THEN
60: INTO ZX_LINES_DET_FACTORS(
61: INTERNAL_ORGANIZATION_ID
62: ,APPLICATION_ID
63: ,ENTITY_CODE
64: ,EVENT_CLASS_CODE

Line 425: INTO ZX_LINES (

421: ,LAST_UPDATED_BY
422: ,LAST_UPDATE_LOGIN
423: )
424: WHEN (trx_line_type = 'TAX') THEN
425: INTO ZX_LINES (
426: TAX_LINE_ID
427: ,INTERNAL_ORGANIZATION_ID
428: ,APPLICATION_ID
429: ,ENTITY_CODE

Line 1290: -- zx_lines columns start from here

1286: --NULL TRX_LINE_PRECISION,
1287: --NULL TRX_LINE_MAU,
1288: --NULL TRX_LINE_CURRENCY_CONV_TYPE,
1289:
1290: -- zx_lines columns start from here
1291:
1292: custtrxl.tax_line_id TAX_LINE_ID,
1293: DECODE(custtrxl.line_type,
1294: 'TAX', RANK() OVER (

Line 1763: (SELECT 1 FROM zx_lines_det_factors zxl

1759: AND rates.tax_status_code = status.tax_status_code(+)
1760: AND rates.content_owner_id = status.content_owner_id(+)
1761: AND NVL(arsysparam.tax_code, '!') <> 'Localization'
1762: AND NOT EXISTS
1763: (SELECT 1 FROM zx_lines_det_factors zxl
1764: WHERE zxl.APPLICATION_ID = 222
1765: AND zxl.EVENT_CLASS_CODE = DECODE(types.type,
1766: 'INV','INVOICE',
1767: 'CM', 'CREDIT_MEMO',

Line 1850: INTO ZX_LINES_DET_FACTORS(

1846:
1847:
1848: INSERT ALL
1849: WHEN trx_line_type IN ('LINE' ,'CB') THEN
1850: INTO ZX_LINES_DET_FACTORS(
1851: INTERNAL_ORGANIZATION_ID
1852: ,APPLICATION_ID
1853: ,ENTITY_CODE
1854: ,EVENT_CLASS_CODE

Line 2215: INTO ZX_LINES (

2211: ,LAST_UPDATED_BY
2212: ,LAST_UPDATE_LOGIN
2213: )
2214: WHEN (trx_line_type = 'TAX') THEN
2215: INTO ZX_LINES (
2216: TAX_LINE_ID
2217: ,INTERNAL_ORGANIZATION_ID
2218: ,APPLICATION_ID
2219: ,ENTITY_CODE

Line 3072: -- zx_lines columns start from here

3068: --NULL TRX_LINE_PRECISION,
3069: --NULL TRX_LINE_MAU,
3070: --NULL TRX_LINE_CURRENCY_CONV_TYPE,
3071:
3072: -- zx_lines columns start from here
3073:
3074: custtrxl.tax_line_id TAX_LINE_ID,
3075: DECODE(custtrxl.line_type,
3076: 'TAX', RANK() OVER (