eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on AP_INVOICES

Line 141: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT11%TYPE INDEX BY BINARY_INTEGER;

137: TYPE GDF_RA_BATCH_SOURCES_ATT7_TBL IS TABLE OF
138: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT7%TYPE INDEX BY BINARY_INTEGER;
139:
140: TYPE GDF_AP_INV_ATT11_TBL IS TABLE OF
141: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT11%TYPE INDEX BY BINARY_INTEGER;
142:
143: TYPE GDF_AP_INV_ATT12_TBL IS TABLE OF
144: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT12%TYPE INDEX BY BINARY_INTEGER;
145:

Line 144: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT12%TYPE INDEX BY BINARY_INTEGER;

140: TYPE GDF_AP_INV_ATT11_TBL IS TABLE OF
141: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT11%TYPE INDEX BY BINARY_INTEGER;
142:
143: TYPE GDF_AP_INV_ATT12_TBL IS TABLE OF
144: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT12%TYPE INDEX BY BINARY_INTEGER;
145:
146: TYPE zxclpplr_doc_sub_typ_rec IS RECORD(
147: CL_DOC_SUB_TYPE ZX_REP_TRX_DETAIL_T.DOCUMENT_SUB_TYPE%TYPE,
148: CL_NUM_OF_DOC ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE,

Line 794: ap_invoices apinv

790: l_tax_rate_tbl,
791: l_document_sub_type_tbl,
792: l_trx_line_dist_id_tbl
793: FROM zx_rep_trx_detail_t itf,
794: ap_invoices apinv
795: WHERE itf.request_id = p_request_id
796: AND itf.trx_id = apinv.invoice_id
797: AND itf.tax_type_code = P_TAX_TYPE_CODE
798: AND apinv.global_attribute12 >= P_TRANSACTION_LETTER_FROM

Line 843: gdf_ap_invoices_att13,

839:
840: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
841: detail_tax_line_id,
842: numeric9,
843: gdf_ap_invoices_att13,
844: created_by,
845: creation_date,
846: last_updated_by,
847: last_update_date,

Line 912: ap_invoices_all apinv --Bug 5415028

908: l_tax_rate_tbl,
909: l_document_sub_type_tbl,
910: l_trx_line_dist_id_tbl
911: FROM zx_rep_trx_detail_t itf,
912: ap_invoices_all apinv --Bug 5415028
913: WHERE itf.request_id = P_REQUEST_ID
914: AND itf.tax_type_code = P_VAT_TAX_TYPE
915: -- OR itf.tax_rate = 0)
916: --itf.tax_type_code = 'Exempt')

Line 1043: gdf_ap_invoices_att11,

1039: numeric8,
1040: numeric2,
1041: numeric3,
1042: numeric12,
1043: gdf_ap_invoices_att11,
1044: gdf_ap_invoices_att12,
1045: created_by,
1046: creation_date,
1047: last_updated_by,

Line 1044: gdf_ap_invoices_att12,

1040: numeric2,
1041: numeric3,
1042: numeric12,
1043: gdf_ap_invoices_att11,
1044: gdf_ap_invoices_att12,
1045: created_by,
1046: creation_date,
1047: last_updated_by,
1048: last_update_date,

Line 1081: ap_invoices_all apinv

1077:
1078: DELETE FROM zx_rep_trx_jx_ext_t
1079: WHERE detail_tax_line_id not in ( SELECT min(itf.detail_tax_line_id)
1080: FROM zx_rep_trx_detail_t itf,
1081: ap_invoices_all apinv
1082: WHERE itf.request_id = P_REQUEST_ID
1083: AND itf.tax_type_code = P_VAT_TAX_TYPE
1084: AND itf.trx_id = apinv.invoice_id
1085: AND apinv.global_attribute12 <> NVL(P_EXCLUDING_TRX_LETTER,'$') --Bug 5415028

Line 1175: ap_invoices apinv

1171: NVL(itf1.billing_trading_partner_id,
1172: itf1.shipping_trading_partner_id) bill_from_party_id,
1173: itf1.internal_organization_id
1174: FROM zx_rep_trx_detail_t itf1,
1175: ap_invoices apinv
1176: WHERE itf1.request_id = P_REQUEST_ID
1177: AND apinv.invoice_id = itf1.trx_id
1178: -- AND itf1.posted_flag = 'Y'
1179: AND itf1.tax_type_code = P_VAT_TAX_TYPE

Line 1210: ap_invoices apinv

1206: NVL(itf1.billing_trading_partner_id,
1207: itf1.shipping_trading_partner_id) bill_from_party_id,
1208: itf1.internal_organization_id
1209: FROM zx_rep_trx_detail_t itf1,
1210: ap_invoices apinv
1211: WHERE itf1.request_id = P_REQUEST_ID
1212: AND apinv.invoice_id = itf1.trx_id
1213: -- AND itf1.posted_flag = 'Y'
1214: AND itf1.tax_type_code = 'Exempt'

Line 1246: ap_invoices apinv

1242: NVL(itf1.billing_trading_partner_id,
1243: itf1.shipping_trading_partner_id) bill_from_party_id,
1244: itf1.internal_organization_id
1245: FROM zx_rep_trx_detail_t itf1,
1246: ap_invoices apinv
1247: WHERE itf1.request_id = P_REQUEST_ID
1248: AND apinv.invoice_id = itf1.trx_id
1249: -- AND itf1.posted_flag = 'Y'
1250: AND itf1.tax_type_code = P_NON_TAXAB_TAX_TYPE

Line 1272: ap_invoices apinv2

1268: null tax_rate,
1269: null tax_rate_id,
1270: null document_sub_type
1271: FROM zx_rep_trx_detail_t itf2,
1272: ap_invoices apinv2
1273: WHERE itf2.request_id = P_REQUEST_ID
1274: AND apinv2.invoice_id = itf2.trx_id
1275: AND itf2.tax_type_code = P_NON_TAXAB_TAX_TYPE
1276: GROUP BY itf2.trx_id

Line 1500: gdf_ap_invoices_att13,

1496: attribute4,
1497: attribute19,
1498: attribute23,
1499: attribute20,
1500: gdf_ap_invoices_att13,
1501: attribute21,
1502: attribute22,
1503: created_by,
1504: creation_date,

Line 8560: | from ap_invoices_all table to meet the requirement in the flat file |

8556: | Type : Private |
8557: | Pre-req : None |
8558: | Function : |
8559: | This function returns the DGI document type |
8560: | from ap_invoices_all table to meet the requirement in the flat file |
8561: | |
8562: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AP |
8563: | |
8564: | Parameters : |

Line 8607: FROM ap_invoices_all

8603: global_attribute13
8604: INTO l_gdf_ap_inv_att11_tbl(p_trx_id_tbl(i)),
8605: l_gdf_ap_inv_att12_tbl(p_trx_id_tbl(i)),
8606: l_dgi_doc_type_tbl(p_trx_id_tbl(i))
8607: FROM ap_invoices_all
8608: WHERE invoice_id = p_trx_id_tbl(i);
8609:
8610: X_GDF_AP_INV_ATT11_TBL(i) := l_gdf_ap_inv_att11_tbl(p_trx_id_tbl(i));
8611: X_GDF_AP_INV_ATT12_TBL(i) := l_gdf_ap_inv_att12_tbl(p_trx_id_tbl(i));

Line 9516: FROM ap_invoices_all

9512: -- IF l_rep_cai_num_tbl(p_trx_id_tbl(i)) IS NULL THEN
9513: SELECT nvl(global_attribute19,0),nvl(global_attribute20,' ')
9514: INTO l_cai_num_tbl(p_trx_id_tbl(i)),
9515: l_cai_due_date_tbl(p_trx_id_tbl(i))
9516: FROM ap_invoices_all
9517: WHERE invoice_id = P_TRX_ID_TBL(i)
9518: AND org_id = P_INTERNAL_ORG_ID(i);
9519: -- END IF;
9520: