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 OKL_TRX_AP_INVOICES_B

Line 960: ,okl_trx_ap_invoices_b tap

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
963: trunc(tap.date_invoiced) BETWEEN
964: NVL(p_from_date, SYSDATE-10000) AND NVL(p_to_date, SYSDATE+10000)

Line 1051: ,okl_trx_ap_invoices_b tap

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
1054: trunc(tap.date_invoiced) BETWEEN
1055: NVL(p_from_date, SYSDATE-10000) AND NVL(p_to_date, SYSDATE+10000)

Line 1729: ,okl_trx_ap_invoices_b tap

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
1732: ,OKL_STRM_TYPE_B sty -- cklee 09/13/07
1733: WHERE

Line 1800: ,okl_trx_ap_invoices_b tap

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
1803: ,OKL_STRM_TYPE_B sty -- cklee 09/13/07
1804: WHERE

Line 1901: ,okl_trx_ap_invoices_b tap

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
1904: WHERE
1905: NVL(tap.trx_status_code, 'ENTERED') in ( 'ENTERED', 'APPROVED' )

Line 1982: ,okl_trx_ap_invoices_b tap

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
1985: WHERE
1986: NVL(tap.trx_status_code, 'ENTERED') in ( 'ENTERED', 'APPROVED' )

Line 3059: ,okl_trx_ap_invoices_b tap

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
3062: trunc(tap.date_invoiced) BETWEEN
3063: NVL(p_from_date,SYSDATE-10000) AND NVL(p_to_date, SYSDATE+10000)

Line 3116: ,okl_trx_ap_invoices_b tap

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
3120: NVL(p_from_date,SYSDATE-10000) AND NVL(p_to_date,SYSDATE+10000)

Line 3123: AND acc_db.source_table (+)= 'OKL_TRX_AP_INVOICES_B'

3119: trunc(tap.date_invoiced) BETWEEN
3120: NVL(p_from_date,SYSDATE-10000) AND NVL(p_to_date,SYSDATE+10000)
3121: AND acc_db.cr_dr_flag (+) = 'D'
3122: AND acc_cr.cr_dr_flag (+) = 'C'
3123: AND acc_db.source_table (+)= 'OKL_TRX_AP_INVOICES_B'
3124: AND acc_cr.source_table (+)= 'OKL_TRX_AP_INVOICES_B'
3125: AND tap.id = acc_db.source_id (+)
3126: AND tap.id = acc_cr.source_id (+)
3127: AND povs.vendor_site_id = tap.ipvs_id

Line 3124: AND acc_cr.source_table (+)= 'OKL_TRX_AP_INVOICES_B'

3120: NVL(p_from_date,SYSDATE-10000) AND NVL(p_to_date,SYSDATE+10000)
3121: AND acc_db.cr_dr_flag (+) = 'D'
3122: AND acc_cr.cr_dr_flag (+) = 'C'
3123: AND acc_db.source_table (+)= 'OKL_TRX_AP_INVOICES_B'
3124: AND acc_cr.source_table (+)= 'OKL_TRX_AP_INVOICES_B'
3125: AND tap.id = acc_db.source_id (+)
3126: AND tap.id = acc_cr.source_id (+)
3127: AND povs.vendor_site_id = tap.ipvs_id
3128: AND tap.org_id = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

Line 3169: ,okl_trx_ap_invoices_b tap

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' )
3173: AND trunc(tap.date_invoiced) BETWEEN

Line 3231: l_previous_tap_id okl_trx_ap_invoices_b.id%TYPE := NULL;

3227: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
3228: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
3229: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
3230:
3231: l_previous_tap_id okl_trx_ap_invoices_b.id%TYPE := NULL;
3232: l_previous_xpi_id okl_ext_sell_invs_b.id%TYPE := NULL;
3233:
3234: CURSOR l_curr_conv_csr( cp_khr_id NUMBER ) IS
3235: SELECT currency_code

Line 3666: UPDATE okl_trx_ap_invoices_b

3662: -- Update internal AP table for Success
3663: -----------------------------------------------------------------
3664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Successfully Prepared Invoice Number : ' || r_invoice.invoice_number);
3665:
3666: UPDATE okl_trx_ap_invoices_b
3667: SET trx_status_code = 'PROCESSED'
3668: WHERE id = r_invoice.tap_id;
3669:
3670: ELSE

Line 3689: UPDATE okl_trx_ap_invoices_b

3685:
3686: END LOOP;
3687: END IF;
3688:
3689: UPDATE okl_trx_ap_invoices_b
3690: SET trx_status_code = 'ERROR'
3691: WHERE id = r_invoice.tap_id;
3692:
3693: UPDATE OKL_EXT_PAY_INVS_b

Line 4104: UPDATE okl_trx_ap_invoices_b

4100: -- Update internal AP table for Success
4101: -----------------------------------------------------------------
4102: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Successfully Prepared Invoice Number : ' || fund_rec.invoice_number);
4103:
4104: UPDATE okl_trx_ap_invoices_b
4105: SET trx_status_code = 'PROCESSED'
4106: WHERE id = fund_rec.tap_id;
4107: ELSE
4108: -----------------------------------------------------------------

Line 4126: UPDATE okl_trx_ap_invoices_b

4122:
4123: END LOOP;
4124: END IF;
4125:
4126: UPDATE okl_trx_ap_invoices_b
4127: SET trx_status_code = 'ERROR'
4128: WHERE id = fund_rec.tap_id;
4129:
4130: UPDATE OKL_EXT_PAY_INVS_b

Line 4263: l_previous_tap_id okl_trx_ap_invoices_b.id%TYPE := NULL;

4259: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
4260: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
4261: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
4262:
4263: l_previous_tap_id okl_trx_ap_invoices_b.id%TYPE := NULL;
4264: l_previous_xpi_id okl_ext_sell_invs_b.id%TYPE := NULL;
4265:
4266: CURSOR l_curr_conv_csr( cp_khr_id NUMBER ) IS
4267: SELECT currency_code