APPS.ZX_JL_EXTRACT_PKG dependencies on AP_INVOICES_ALL

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 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));