APPS.ZX_JL_EXTRACT_PKG dependencies on AP_INVOICES_ALL

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 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 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: