DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on ZX_REP_TRX_JX_EXT_T_S

Line 850: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

846: last_updated_by,
847: last_update_date,
848: last_update_login,
849: request_id)
850: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
851: l_detail_tax_line_id_tbl(i),
852: l_vat_amt_tbl(i),
853: l_dgi_doc_type_tbl(i),
854: fnd_global.user_id,

Line 1051: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1047: last_updated_by,
1048: last_update_date,
1049: last_update_login,
1050: request_id)
1051: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1052: l_detail_tax_line_id_tbl(i),
1053: l_vat_amt_tbl(i),
1054: l_taxable_amt_tbl(i),
1055: l_non_taxable_amt_tbl(i),

Line 1509: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1505: last_updated_by,
1506: last_update_date,
1507: last_update_login,
1508: request_id)
1509: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1510: l_detail_tax_line_id_tbl(i),
1511: l_vat_amt_tbl(i),
1512: l_taxable_amt_tbl(i),
1513: l_non_taxable_amt_tbl(i),

Line 1754: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1750: last_updated_by,
1751: last_update_date,
1752: last_update_login,
1753: request_id)
1754: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1755: l_detail_tax_line_id_tbl(i),
1756: l_vat_amt_tbl(i),
1757: l_taxable_amt_tbl(i),
1758: l_vat_exempt_amt_tbl(i),

Line 1870: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1866: last_updated_by,
1867: last_update_date,
1868: last_update_login,
1869: request_id)
1870: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1871: l_detail_tax_line_id_tbl(i),
1872: l_tax_auth_categ_tbl(i),
1873: fnd_global.user_id,
1874: sysdate,

Line 2160: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2156: last_updated_by,
2157: last_update_date,
2158: last_update_login
2159: )
2160: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2161: l_detail_tax_line_id_tbl(i),
2162: l_taxable_amt_tbl(i),
2163: l_vat_perc_amt_tbl(i),
2164: l_total_doc_amt_tbl(i),

Line 2475: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2471: last_updated_by,
2472: last_update_date,
2473: last_update_login,
2474: request_id)
2475: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2476: l_detail_tax_line_id_tbl(i),
2477: l_vat_amt_tbl(i),
2478: l_taxable_amt_tbl(i),
2479: l_non_taxable_amt_tbl(i),

Line 3005: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3001: last_updated_by,
3002: last_update_date,
3003: last_update_login,
3004: request_id)
3005: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
3006: l_detail_tax_line_id_tbl(i),
3007: l_vat_amt_tbl(i),
3008: l_taxable_amt_tbl(i),
3009: l_non_taxable_amt_tbl(i),

Line 3182: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3178: last_updated_by,
3179: last_update_date,
3180: last_update_login,
3181: request_id)
3182: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
3183: l_detail_tax_line_id_tbl(i),
3184: l_prov_perc_amt_tbl(i),
3185: l_munic_perc_amt_tbl(i),
3186: l_dgi_code_tbl(i),

Line 3387: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3383: last_updated_by,
3384: last_update_date,
3385: last_update_login,
3386: request_id)
3387: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
3388: l_detail_tax_line_id_tbl(i),
3389: l_vat_amt_tbl(i),
3390: l_taxable_amt_tbl(i),
3391: l_vat_exempt_amt_tbl(i),

Line 3532: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3528: last_updated_by,
3529: last_update_date,
3530: last_update_login,
3531: request_id)
3532: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
3533: l_detail_tax_line_id_tbl(i),
3534: (l_total_doc_amt_tbl(i) + l_vat_amt_tbl(i)) * l_exchange_rate_tbl(i), --Bug 5396444
3535: l_extended_amt_tbl(i) * l_exchange_rate_tbl(i),--Bug 5396444
3536: l_vat_amt_tbl(i) * l_exchange_rate_tbl(i),--Bug 5396444

Line 3607: (SELECT zx_rep_trx_jx_ext_t_s.nextval,

3603: last_updated_by,
3604: last_update_date,
3605: last_update_login,
3606: request_id)
3607: (SELECT zx_rep_trx_jx_ext_t_s.nextval,
3608: dtl.detail_tax_line_id,
3609: l_tax_catg_desc,
3610: dtl.created_by,
3611: dtl.creation_date,