APPS.ZX_ON_FLY_TRX_UPGRADE_AR_PKG dependencies on ZX_LINES

Line 84: INTO ZX_LINES_DET_FACTORS(

80:
81:
82: INSERT ALL
83: WHEN trx_line_type IN ('LINE' ,'CB') THEN
84: INTO ZX_LINES_DET_FACTORS(
85: INTERNAL_ORGANIZATION_ID
86: ,APPLICATION_ID
87: ,ENTITY_CODE
88: ,EVENT_CLASS_CODE

Line 449: INTO ZX_LINES (

445: ,LAST_UPDATED_BY
446: ,LAST_UPDATE_LOGIN
447: )
448: WHEN (trx_line_type = 'TAX') THEN
449: INTO ZX_LINES (
450: TAX_LINE_ID
451: ,INTERNAL_ORGANIZATION_ID
452: ,APPLICATION_ID
453: ,ENTITY_CODE

Line 1367: -- zx_lines columns start from here

1363: --NULL TRX_LINE_PRECISION,
1364: --NULL TRX_LINE_MAU,
1365: --NULL TRX_LINE_CURRENCY_CONV_TYPE,
1366:
1367: -- zx_lines columns start from here
1368:
1369: custtrxl.tax_line_id TAX_LINE_ID,
1370: DECODE(custtrxl.line_type,
1371: 'TAX', RANK() OVER (

Line 1843: (SELECT 1 FROM zx_lines_det_factors zxl

1839: AND rates.tax_status_code = status.tax_status_code(+)
1840: AND rates.content_owner_id = status.content_owner_id(+)
1841: AND NVL(arsysparam.tax_code, '!') <> 'Localization'
1842: AND NOT EXISTS
1843: (SELECT 1 FROM zx_lines_det_factors zxl
1844: WHERE zxl.APPLICATION_ID = 222
1845: AND zxl.EVENT_CLASS_CODE = DECODE(types.type,
1846: 'INV','INVOICE',
1847: 'CM', 'CREDIT_MEMO',

Line 1931: INTO ZX_LINES_DET_FACTORS(

1927:
1928:
1929: INSERT ALL
1930: WHEN trx_line_type IN ('LINE' ,'CB') THEN
1931: INTO ZX_LINES_DET_FACTORS(
1932: INTERNAL_ORGANIZATION_ID
1933: ,APPLICATION_ID
1934: ,ENTITY_CODE
1935: ,EVENT_CLASS_CODE

Line 2296: INTO ZX_LINES (

2292: ,LAST_UPDATED_BY
2293: ,LAST_UPDATE_LOGIN
2294: )
2295: WHEN (trx_line_type = 'TAX') THEN
2296: INTO ZX_LINES (
2297: TAX_LINE_ID
2298: ,INTERNAL_ORGANIZATION_ID
2299: ,APPLICATION_ID
2300: ,ENTITY_CODE

Line 3206: -- zx_lines columns start from here

3202: --NULL TRX_LINE_PRECISION,
3203: --NULL TRX_LINE_MAU,
3204: --NULL TRX_LINE_CURRENCY_CONV_TYPE,
3205:
3206: -- zx_lines columns start from here
3207:
3208: custtrxl.tax_line_id TAX_LINE_ID,
3209: DECODE(custtrxl.line_type,
3210: 'TAX', RANK() OVER (