[Home] [Help]
952: ,tpl.REF_LINE_NUMBER
953: ,tpl.CNSLD_LINE_NUMBER
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
953: ,tpl.CNSLD_LINE_NUMBER
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
1043: ,tpl.REF_LINE_NUMBER
1044: ,tpl.CNSLD_LINE_NUMBER
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
1044: ,tpl.CNSLD_LINE_NUMBER
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
1723: ,tap.VPA_ID
1724: ,acc_cr.code_combination_id
1725: ,COUNT(1) line_count
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
1794: ,tap.VPA_ID
1795: ,acc_cr.code_combination_id
1796: ,COUNT(1) line_count
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
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,
1853: p_set_of_books_id okl_trx_ap_invs_all_b.set_of_books_id%type,
1854: p_code_combination_id okl_trns_acc_dstrs.code_combination_id%type,
1855: p_currency_code okl_trx_ap_invs_all_b.currency_code%type,
1856: p_currency_conversion_type okl_trx_ap_invs_all_b.currency_conversion_type%type,
1857: p_currency_conversion_rate okl_trx_ap_invs_all_b.currency_conversion_rate%type,
1858: p_currency_conversion_date date,
1893: ,tap.VPA_ID
1894: -- ,nvl(tpl.adv_grouping_flag, 'Y') adv_grouping_flag -- cklee 09/14/07
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
1894: -- ,nvl(tpl.adv_grouping_flag, 'Y') adv_grouping_flag -- cklee 09/14/07
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
1974: ,tap.VPA_ID
1975: -- ,nvl(tpl.adv_grouping_flag, 'Y') adv_grouping_flag -- cklee 09/14/07
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
1975: -- ,nvl(tpl.adv_grouping_flag, 'Y') adv_grouping_flag -- cklee 09/14/07
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
2622: DSTRS.AMOUNT,
2623: DSTRS.CODE_COMBINATION_ID,
2624: DSTRS.CR_DR_FLAG
2625: FROM OKL_TXL_AP_INV_LNS_B TPL,
2626: OKL_TRNS_ACC_DSTRS DSTRS
2627: WHERE TPL.CNSLD_AP_INV_ID = p_cnsld_inv_id
2628: AND TPL.ID = DSTRS.SOURCE_ID
2629: AND DSTRS.SOURCE_TABLE = 'OKL_TXL_AP_INV_LNS_B';
2630:
3051: ,tpl.amount invoice_amount
3052: ,acc_db.amount line_amount
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
3052: ,acc_db.amount line_amount
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
3109: ,acc_db.amount line_amount
3110: ,povs.vendor_id
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
3110: ,povs.vendor_id
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
3162: ,acc_db.amount line_amount
3163: ,povs.vendor_id
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
3163: ,povs.vendor_id
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