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.OKL_PAY_INVOICES_CONS_PVT dependencies on PO_VENDOR_SITES_ALL

Line 958: ,po_vendor_sites_all povs

954: --end:| 02-May-2007 cklee Disbursement changes for R12B |
955: FROM
956: okl_trns_acc_dstrs acc_db
957: ,okl_trns_acc_dstrs acc_cr
958: ,po_vendor_sites_all povs
959: ,okl_txl_ap_inv_lns_b tpl
960: ,okl_trx_ap_invoices_b tap
961: WHERE
962: NVL(tap.trx_status_code, 'ENTERED') in ( 'ENTERED', 'APPROVED' ) AND

Line 1049: ,po_vendor_sites_all povs

1045: --end:| 02-May-2007 cklee Disbursement changes for R12B |
1046: FROM
1047: okl_trns_acc_dstrs acc_db
1048: ,okl_trns_acc_dstrs acc_cr
1049: ,po_vendor_sites_all povs
1050: ,okl_txl_ap_inv_lns_b tpl
1051: ,okl_trx_ap_invoices_b tap
1052: WHERE
1053: NVL(tap.trx_status_code, 'APPROVED') in ( 'APPROVED') AND

Line 1730: ,po_vendor_sites_all povs

1726: FROM
1727: okl_trns_acc_dstrs acc_cr
1728: ,okl_txl_ap_inv_lns_b tpl
1729: ,okl_trx_ap_invoices_b tap
1730: ,po_vendor_sites_all povs
1731: -- ,okc_k_headers_all_b chr -- cklee 09/13/07
1732: ,OKL_STRM_TYPE_B sty -- cklee 09/13/07
1733: WHERE
1734: NVL(tap.trx_status_code, 'ENTERED') in ( 'ENTERED', 'APPROVED' ) AND

Line 1801: ,po_vendor_sites_all povs

1797: FROM
1798: okl_trns_acc_dstrs acc_cr
1799: ,okl_txl_ap_inv_lns_b tpl
1800: ,okl_trx_ap_invoices_b tap
1801: ,po_vendor_sites_all povs
1802: -- ,okc_k_headers_all_b chr -- cklee 09/13/07
1803: ,OKL_STRM_TYPE_B sty -- cklee 09/13/07
1804: WHERE
1805: NVL(tap.trx_status_code, 'APPROVED') in ( 'APPROVED') AND

Line 1848: p_vendor_id po_vendor_sites_all.vendor_id%type,

1844:
1845: --
1846: -- details cursor to get all invoice lines
1847: CURSOR c_invoice (
1848: p_vendor_id po_vendor_sites_all.vendor_id%type,
1849: p_ipvs_id okl_trx_ap_invs_all_b.ipvs_id%type,
1850: p_pay_group_lookup_code okl_trx_ap_invs_all_b.pay_group_lookup_code%type,
1851: p_payment_method_code okl_trx_ap_invs_all_b.payment_method_code%type,
1852: p_ippt_id okl_trx_ap_invs_all_b.ippt_id%type,

Line 1899: ,po_vendor_sites_all povs

1895: ,sty.stream_type_purpose -- cklee 09/14/07
1896: FROM
1897: okl_trns_acc_dstrs acc_db
1898: ,okl_trns_acc_dstrs acc_cr
1899: ,po_vendor_sites_all povs
1900: ,okl_txl_ap_inv_lns_b tpl
1901: ,okl_trx_ap_invoices_b tap
1902: -- ,okc_k_headers_all_b chr -- cklee 09/13/07
1903: ,OKL_STRM_TYPE_B sty -- cklee 09/13/07

Line 1980: ,po_vendor_sites_all povs

1976: ,sty.stream_type_purpose -- cklee 09/14/07
1977: FROM
1978: okl_trns_acc_dstrs acc_db
1979: ,okl_trns_acc_dstrs acc_cr
1980: ,po_vendor_sites_all povs
1981: ,okl_txl_ap_inv_lns_b tpl
1982: ,okl_trx_ap_invoices_b tap
1983: -- ,okc_k_headers_all_b chr -- cklee 09/13/07
1984: ,OKL_STRM_TYPE_B sty -- cklee 09/13/07

Line 3057: ,po_vendor_sites_all povs

3053: ,povs.vendor_id
3054: FROM
3055: okl_trns_acc_dstrs acc_db
3056: ,okl_trns_acc_dstrs acc_cr
3057: ,po_vendor_sites_all povs
3058: ,okl_txl_ap_inv_lns_b tpl
3059: ,okl_trx_ap_invoices_b tap
3060: WHERE
3061: NVL(tap.trx_status_code, 'ENTERED') in ( 'ENTERED', 'APPROVED' ) AND

Line 3115: ,po_vendor_sites_all povs

3111: -- ,tap.FUNDING_TYPE_CODE -cklee
3112: FROM
3113: okl_trns_acc_dstrs acc_db
3114: ,okl_trns_acc_dstrs acc_cr
3115: ,po_vendor_sites_all povs
3116: ,okl_trx_ap_invoices_b tap
3117: WHERE
3118: NVL(tap.trx_status_code, 'ENTERED') in ( 'APPROVED' ) AND
3119: trunc(tap.date_invoiced) BETWEEN

Line 3168: ,po_vendor_sites_all povs

3164: -- ,tap.FUNDING_TYPE_CODE -- cklee
3165: FROM
3166: okl_trns_acc_dstrs acc_db
3167: ,okl_trns_acc_dstrs acc_cr
3168: ,po_vendor_sites_all povs
3169: ,okl_trx_ap_invoices_b tap
3170: ,okl_txl_ap_inv_lns_b tpl
3171: WHERE
3172: NVL(tap.trx_status_code, 'ENTERED') in ( 'APPROVED' )

Line 4290: from po_vendor_sites_all

4286: l_vendor_rec l_vendor_csr%ROWTYPE;
4287:
4288: CURSOR l_vendor_site_csr (vId NUMBER, VSite VARCHAR) IS
4289: select vendor_site_id
4290: from po_vendor_sites_all
4291: where vendor_id = nvl(vId, -1)
4292: and vendor_site_code = nvl(VSite, 'XX');
4293:
4294: l_vendor_site_rec l_vendor_site_csr%ROWTYPE;

Line 4669: from po_vendor_sites_all povs

4665: -- l_vendor_rec l_vendor_csr%ROWTYPE;
4666:
4667: CURSOR l_vendor_site_csr (VSite VARCHAR) IS
4668: select vendor_site_id
4669: from po_vendor_sites_all povs
4670: where povs.vendor_site_code = VSite;
4671:
4672: -- l_vendor_site_rec l_vendor_site_csr%ROWTYPE;
4673: