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.

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: --Private Methods Declarations
147: -----------------------------------------
148: l_err_msg VARCHAR2(120);

Line 754: ap_invoices apinv

750: l_trx_id_tbl,
751: l_tax_rate_tbl,
752: l_document_sub_type_tbl
753: FROM zx_rep_trx_detail_t itf,
754: ap_invoices apinv
755: WHERE itf.request_id = p_request_id
756: AND itf.trx_id = apinv.invoice_id
757: AND itf.tax_type_code = P_TAX_TYPE_CODE
758: AND apinv.global_attribute12 >= P_TRANSACTION_LETTER_FROM

Line 801: gdf_ap_invoices_att13,

797:
798: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
799: detail_tax_line_id,
800: numeric9,
801: gdf_ap_invoices_att13,
802: created_by,
803: creation_date,
804: last_updated_by,
805: last_update_date,

Line 866: ap_invoices_all apinv --Bug 5415028

862: l_trx_id_tbl,
863: l_tax_rate_tbl,
864: l_document_sub_type_tbl
865: FROM zx_rep_trx_detail_t itf,
866: ap_invoices_all apinv --Bug 5415028
867: WHERE itf.request_id = P_REQUEST_ID
868: AND itf.tax_type_code = P_VAT_TAX_TYPE
869: -- OR itf.tax_rate = 0)
870: --itf.tax_type_code = 'Exempt')

Line 991: gdf_ap_invoices_att11,

987: numeric8,
988: numeric2,
989: numeric3,
990: numeric12,
991: gdf_ap_invoices_att11,
992: gdf_ap_invoices_att12,
993: created_by,
994: creation_date,
995: last_updated_by,

Line 992: gdf_ap_invoices_att12,

988: numeric2,
989: numeric3,
990: numeric12,
991: gdf_ap_invoices_att11,
992: gdf_ap_invoices_att12,
993: created_by,
994: creation_date,
995: last_updated_by,
996: last_update_date,

Line 1105: ap_invoices apinv

1101: itf1.billing_tp_address_id) bill_from_site_id,
1102: NVL(itf1.billing_trading_partner_id,
1103: itf1.shipping_trading_partner_id) bill_from_party_id
1104: FROM zx_rep_trx_detail_t itf1,
1105: ap_invoices apinv
1106: WHERE itf1.request_id = P_REQUEST_ID
1107: AND apinv.invoice_id = itf1.trx_id
1108: -- AND itf1.posted_flag = 'Y'
1109: AND itf1.tax_type_code = P_VAT_TAX_TYPE

Line 1138: ap_invoices apinv

1134: itf1.billing_tp_address_id) bill_from_site_id,
1135: NVL(itf1.billing_trading_partner_id,
1136: itf1.shipping_trading_partner_id) bill_from_party_id
1137: FROM zx_rep_trx_detail_t itf1,
1138: ap_invoices apinv
1139: WHERE itf1.request_id = P_REQUEST_ID
1140: AND apinv.invoice_id = itf1.trx_id
1141: -- AND itf1.posted_flag = 'Y'
1142: AND itf1.tax_type_code = 'Exempt'

Line 1172: ap_invoices apinv

1168: itf1.billing_tp_address_id) bill_from_site_id,
1169: NVL(itf1.billing_trading_partner_id,
1170: itf1.shipping_trading_partner_id) bill_from_party_id
1171: FROM zx_rep_trx_detail_t itf1,
1172: ap_invoices apinv
1173: WHERE itf1.request_id = P_REQUEST_ID
1174: AND apinv.invoice_id = itf1.trx_id
1175: -- AND itf1.posted_flag = 'Y'
1176: AND itf1.tax_type_code = P_NON_TAXAB_TAX_TYPE

Line 1197: ap_invoices apinv2

1193: null tax_rate,
1194: null tax_rate_id,
1195: null document_sub_type
1196: FROM zx_rep_trx_detail_t itf2,
1197: ap_invoices apinv2
1198: WHERE itf2.request_id = P_REQUEST_ID
1199: AND apinv2.invoice_id = itf2.trx_id
1200: AND itf2.tax_type_code = P_NON_TAXAB_TAX_TYPE
1201: GROUP BY itf2.trx_id

Line 1420: gdf_ap_invoices_att13,

1416: attribute4,
1417: attribute19,
1418: attribute23,
1419: attribute20,
1420: gdf_ap_invoices_att13,
1421: attribute21,
1422: attribute22,
1423: created_by,
1424: creation_date,

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

8080: | Type : Private |
8081: | Pre-req : None |
8082: | Function : |
8083: | This function returns the DGI document type |
8084: | from ap_invoices_all table to meet the requirement in the flat file |
8085: | |
8086: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AP |
8087: | |
8088: | Parameters : |

Line 8131: FROM ap_invoices_all

8127: global_attribute13
8128: INTO l_gdf_ap_inv_att11_tbl(p_trx_id_tbl(i)),
8129: l_gdf_ap_inv_att12_tbl(p_trx_id_tbl(i)),
8130: l_dgi_doc_type_tbl(p_trx_id_tbl(i))
8131: FROM ap_invoices_all
8132: WHERE invoice_id = p_trx_id_tbl(i);
8133:
8134: X_GDF_AP_INV_ATT11_TBL(i) := l_gdf_ap_inv_att11_tbl(p_trx_id_tbl(i));
8135: X_GDF_AP_INV_ATT12_TBL(i) := l_gdf_ap_inv_att12_tbl(p_trx_id_tbl(i));