[Home] [Help]
506: l_tax_id ap_tax_codes.tax_id%TYPE;
507: l_SUPP_AWT_TYPE_ID_TYPES JL_ZZ_AP_SUPP_AWT_TYPES.SUPP_AWT_TYPE_ID%TYPE;
508: l_VENDOR_ID PO_VENDORS.VENDOR_ID%TYPE;
509: l_INV_DISTRIB_AWT_ID_INV JL_ZZ_AP_INV_DIS_WH_ALL.INV_DISTRIB_AWT_ID%TYPE;
510: l_INVOICE_ID_INA AP_INVOICES_ALL.INVOICE_ID%TYPE;
511: l_DISTRIBUTION_LINE_NUMBER_IND AP_INVOICE_DISTRIBUTIONS_ALL.DISTRIBUTION_LINE_NUMBER%TYPE;
512: l_INVOICE_DISTRIBUTION_ID_IND AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE;
513: l_START_DATE_SEC_MAX DATE := NULL;
514: l_END_DATE_SEC_MAX DATE := NULL;
520: SELECT APINA.INVOICE_ID,
521: APIND.DISTRIBUTION_LINE_NUMBER,
522: APIND.INVOICE_DISTRIBUTION_ID
523: FROM PO_VENDORS PV,
524: AP_INVOICES APINA,
525: AP_INVOICE_DISTRIBUTIONS APIND,
526: PER_ALL_PEOPLE_F PAPF
527: WHERE PV.VENDOR_ID = APINA.VENDOR_ID
528: AND NVL(pv.employee_id, - 99) = papf.person_id (+)
1863: l_tax_id ap_tax_codes.tax_id%TYPE;
1864: l_SUPP_AWT_TYPE_ID_TYPES JL_ZZ_AP_SUPP_AWT_TYPES.SUPP_AWT_TYPE_ID%TYPE;
1865: l_VENDOR_ID PO_VENDORS.VENDOR_ID%TYPE;
1866: l_INV_DISTRIB_AWT_ID_INV JL_ZZ_AP_INV_DIS_WH_ALL.INV_DISTRIB_AWT_ID%TYPE;
1867: l_INVOICE_ID_INA AP_INVOICES_ALL.INVOICE_ID%TYPE;
1868: l_DISTRIBUTION_LINE_NUMBER_IND AP_INVOICE_DISTRIBUTIONS_ALL.DISTRIBUTION_LINE_NUMBER%TYPE;
1869: l_INVOICE_DISTRIBUTION_ID_IND AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE;
1870: l_INV_DISTRIB_AWT_ID_DIS JL_ZZ_AP_INV_DIS_WH_ALL.INV_DISTRIB_AWT_ID%TYPE;
1871: l_SUPP_AWT_CODE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
1885: SELECT APINA.INVOICE_ID,
1886: APIND.DISTRIBUTION_LINE_NUMBER,
1887: APIND.INVOICE_DISTRIBUTION_ID
1888: FROM PO_VENDORS PV,
1889: AP_INVOICES APINA,
1890: AP_INVOICE_DISTRIBUTIONS APIND,
1891: PER_ALL_PEOPLE_F PAPF
1892: WHERE PV.VENDOR_ID = APINA.VENDOR_ID
1893: AND NVL(pv.employee_id, - 99) = papf.person_id (+)