DBA Data[Home] [Help]

APPS.ZX_JA_EXTRACT_PKG dependencies on ZX_REP_TRX_JX_EXT_T_S

Line 965: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

961: last_updated_by,
962: last_update_date,
963: last_update_login,
964: request_id)
965: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
966: l_detail_tax_line_id_tbl(i),
967: X_GOVERNMENT_TAX_TYPE_TBL(i),
968: X_DEDUCTIBLE_TYPE_TBL(i),
969: fnd_global.user_id,

Line 1036: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1032: last_updated_by,
1033: last_update_date,
1034: last_update_login,
1035: request_id)
1036: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1037: l_detail_tax_line_id_tbl(i),
1038: X_GOVERNMENT_TAX_TYPE_TBL(i),
1039: X_ORG_TRX_NUMBER_TBL(i),
1040: X_REFERENCE_TRX_SRC_TBL(i),

Line 1102: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1098: last_updated_by,
1099: last_update_date,
1100: last_update_login,
1101: request_id)
1102: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1103: l_detail_tax_line_id_tbl(i),
1104: X_EXPORT_METHOD_TBL(i),
1105: X_EXPORT_CERTIFICATE_NAME_TBL(i),
1106: X_EXPORT_TYPE_TBL(i),

Line 1136: zx_rep_trx_jx_ext_t_s.nextval,

1132: last_update_login,
1133: request_id
1134: )
1135: SELECT
1136: zx_rep_trx_jx_ext_t_s.nextval,
1137: dtl.detail_tax_line_id,
1138: types.global_attribute1,
1139: fnd_global.user_id,
1140: sysdate,

Line 1256: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1252: last_updated_by,
1253: last_update_date,
1254: last_update_login,
1255: request_id)
1256: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1257: l_detail_tax_line_id_tbl(i),
1258: l_location_code_tbl(i),
1259: l_address_line_1_tbl(i),
1260: l_address_line_2_tbl(i),

Line 1541: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1537: last_updated_by,
1538: last_update_date,
1539: last_update_login,
1540: request_id)
1541: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1542: l_detail_tax_line_id_tbl(i),
1543: X_GOVERNMENT_TAX_TYPE_TBL(i),
1544: X_DEDUCTIBLE_TYPE_TBL(i),
1545: fnd_global.user_id,

Line 1619: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1615: last_updated_by,
1616: last_update_date,
1617: last_update_login,
1618: request_id)
1619: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1620: l_detail_tax_line_id_tbl(i),
1621: X_GOVERNMENT_TAX_TYPE_TBL(i),
1622: X_DEDUCTIBLE_TYPE_TBL(i),
1623: X_GUI_TYPE_TBL(i),

Line 1676: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1672: last_updated_by,
1673: last_update_date,
1674: last_update_login,
1675: request_id)
1676: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1677: l_detail_tax_line_id_tbl(i),
1678: X_PRINT_DATE_TBL(i),
1679: X_INVOICE_AMOUNT_TBL(i),
1680: X_BASE_AMOUNT_TBL(i),

Line 1720: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1716: last_updated_by,
1717: last_update_date,
1718: last_update_login,
1719: request_id)
1720: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1721: l_detail_tax_line_id_tbl(i),
1722: X_INVOICE_AMOUNT_TBL(i),
1723: X_BASE_AMOUNT_TBL(i),
1724: fnd_global.user_id,

Line 1765: zx_rep_trx_jx_ext_t_s.NEXTVAL,

1761: sysdate,
1762: fnd_global.user_id,
1763: sysdate,
1764: fnd_global.login_id,
1765: zx_rep_trx_jx_ext_t_s.NEXTVAL,
1766: detail_tax_line_id,
1767: document_sub_type,
1768: CASE WHEN tax_line_change= 1 OR tax_recoverable_flag = 'N' THEN taxable_amt
1769: ELSE 0

Line 1895: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1891: last_updated_by,
1892: last_update_date,
1893: last_update_login,
1894: request_id)
1895: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1896: l_detail_tax_line_id_tbl(i),
1897: X_INHOUSE_INV_AMT_TBL(i),
1898: X_SUPPLIER_INV_AMT_TBL(i),
1899: X_INHOUSE_TAX_AMT_TBL(i),

Line 2009: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2005: last_updated_by,
2006: last_update_date,
2007: last_update_login,
2008: request_id)
2009: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2010: l_detail_tax_line_id_tbl(i),
2011: l_location_code_tbl(i),
2012: l_address_line_1_tbl(i),
2013: l_address_line_2_tbl(i),

Line 2700: VALUES ( zx_rep_trx_jx_ext_t_s.nextval,

2696: last_updated_by,
2697: last_update_date,
2698: last_update_login,
2699: request_id)
2700: VALUES ( zx_rep_trx_jx_ext_t_s.nextval,
2701: l_detail_tax_line_id_tbl(i),
2702: l_bank_name,
2703: l_branch_name,
2704: l_bank_account_num,

Line 2727: SELECT zx_rep_trx_jx_ext_t_s.nextval,

2723: last_updated_by,
2724: last_update_date,
2725: last_update_login,
2726: request_id)
2727: SELECT zx_rep_trx_jx_ext_t_s.nextval,
2728: dtl.detail_tax_line_id,
2729: loc.global_attribute5,
2730: loc.global_attribute6,
2731: loc.global_attribute7,