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_TXL_AP_INV_LNS_B

Line 959: ,okl_txl_ap_inv_lns_b tpl

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

Line 967: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

963: trunc(tap.date_invoiced) BETWEEN
964: NVL(p_from_date, SYSDATE-10000) AND NVL(p_to_date, SYSDATE+10000)
965: AND nvl(acc_db.cr_dr_flag(+), 'D') = 'D' --ssiruvol 05May2007
966: AND nvl(acc_cr.cr_dr_flag(+), 'C') = 'C' --ssiruvol 05May2007
967: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
968: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
969: AND tpl.id = acc_db.source_id (+)
970: AND tpl.id = acc_cr.source_id (+)
971: AND povs.vendor_site_id = tap.ipvs_id

Line 968: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

964: NVL(p_from_date, SYSDATE-10000) AND NVL(p_to_date, SYSDATE+10000)
965: AND nvl(acc_db.cr_dr_flag(+), 'D') = 'D' --ssiruvol 05May2007
966: AND nvl(acc_cr.cr_dr_flag(+), 'C') = 'C' --ssiruvol 05May2007
967: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
968: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
969: AND tpl.id = acc_db.source_id (+)
970: AND tpl.id = acc_cr.source_id (+)
971: AND povs.vendor_site_id = tap.ipvs_id
972: AND tap.id = tpl.tap_id

Line 1050: ,okl_txl_ap_inv_lns_b tpl

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

Line 1058: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

1054: trunc(tap.date_invoiced) BETWEEN
1055: NVL(p_from_date, SYSDATE-10000) AND NVL(p_to_date, SYSDATE+10000)
1056: AND nvl(acc_db.cr_dr_flag(+), 'D') = 'D' --ssiruvol 05May2007
1057: AND nvl(acc_cr.cr_dr_flag(+), 'C') = 'C' --ssiruvol 05May2007
1058: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1059: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1060: AND tpl.id = acc_db.source_id (+)
1061: AND tpl.id = acc_cr.source_id (+)
1062: AND povs.vendor_site_id = tap.ipvs_id

Line 1059: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

1055: NVL(p_from_date, SYSDATE-10000) AND NVL(p_to_date, SYSDATE+10000)
1056: AND nvl(acc_db.cr_dr_flag(+), 'D') = 'D' --ssiruvol 05May2007
1057: AND nvl(acc_cr.cr_dr_flag(+), 'C') = 'C' --ssiruvol 05May2007
1058: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1059: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1060: AND tpl.id = acc_db.source_id (+)
1061: AND tpl.id = acc_cr.source_id (+)
1062: AND povs.vendor_site_id = tap.ipvs_id
1063: AND tap.id = tpl.tap_id

Line 1728: ,okl_txl_ap_inv_lns_b tpl

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

Line 1738: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

1734: NVL(tap.trx_status_code, 'ENTERED') in ( 'ENTERED', 'APPROVED' ) AND
1735: trunc(tap.date_invoiced) BETWEEN
1736: NVL(p_from_date, trunc(tap.date_invoiced)) AND NVL(p_to_date, trunc(tap.date_invoiced))
1737: AND nvl(acc_cr.cr_dr_flag(+), 'C') = 'C'
1738: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1739: AND tpl.id = acc_cr.source_id (+)
1740: AND tap.id = tpl.tap_id
1741: AND povs.vendor_site_id = tap.ipvs_id
1742: AND tap.FUNDING_TYPE_CODE IS NULL

Line 1799: ,okl_txl_ap_inv_lns_b tpl

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

Line 1809: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

1805: NVL(tap.trx_status_code, 'APPROVED') in ( 'APPROVED') AND
1806: trunc(tap.date_invoiced) BETWEEN
1807: NVL(p_from_date, trunc(tap.date_invoiced)) AND NVL(p_to_date, trunc(tap.date_invoiced))
1808: AND nvl(acc_cr.cr_dr_flag(+), 'C') = 'C'
1809: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1810: AND tpl.id = acc_cr.source_id (+)
1811: AND tap.id = tpl.tap_id
1812: AND povs.vendor_site_id = tap.ipvs_id
1813: AND tap.FUNDING_TYPE_CODE IS NOT NULL

Line 1900: ,okl_txl_ap_inv_lns_b tpl

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
1904: WHERE

Line 1910: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

1906: AND trunc(tap.date_invoiced) BETWEEN
1907: NVL(p_from_date, trunc(tap.date_invoiced)) AND NVL(p_to_date, trunc(tap.date_invoiced))
1908: AND nvl(acc_db.cr_dr_flag(+), 'D') = 'D' --ssiruvol 05May2007
1909: AND nvl(acc_cr.cr_dr_flag(+), 'C') = 'C' --ssiruvol 05May2007
1910: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1911: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1912: AND tpl.id = acc_db.source_id (+)
1913: AND tpl.id = acc_cr.source_id (+)
1914: AND povs.vendor_site_id = tap.ipvs_id

Line 1911: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

1907: NVL(p_from_date, trunc(tap.date_invoiced)) AND NVL(p_to_date, trunc(tap.date_invoiced))
1908: AND nvl(acc_db.cr_dr_flag(+), 'D') = 'D' --ssiruvol 05May2007
1909: AND nvl(acc_cr.cr_dr_flag(+), 'C') = 'C' --ssiruvol 05May2007
1910: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1911: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1912: AND tpl.id = acc_db.source_id (+)
1913: AND tpl.id = acc_cr.source_id (+)
1914: AND povs.vendor_site_id = tap.ipvs_id
1915: AND tap.id = tpl.tap_id

Line 1981: ,okl_txl_ap_inv_lns_b tpl

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
1985: WHERE

Line 1991: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

1987: AND trunc(tap.date_invoiced) BETWEEN
1988: NVL(p_from_date, trunc(tap.date_invoiced)) AND NVL(p_to_date, trunc(tap.date_invoiced))
1989: AND nvl(acc_db.cr_dr_flag(+), 'D') = 'D' --ssiruvol 05May2007
1990: AND nvl(acc_cr.cr_dr_flag(+), 'C') = 'C' --ssiruvol 05May2007
1991: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1992: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1993: AND tpl.id = acc_db.source_id (+)
1994: AND tpl.id = acc_cr.source_id (+)
1995: AND povs.vendor_site_id = tap.ipvs_id

Line 1992: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

1988: NVL(p_from_date, trunc(tap.date_invoiced)) AND NVL(p_to_date, trunc(tap.date_invoiced))
1989: AND nvl(acc_db.cr_dr_flag(+), 'D') = 'D' --ssiruvol 05May2007
1990: AND nvl(acc_cr.cr_dr_flag(+), 'C') = 'C' --ssiruvol 05May2007
1991: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1992: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
1993: AND tpl.id = acc_db.source_id (+)
1994: AND tpl.id = acc_cr.source_id (+)
1995: AND povs.vendor_site_id = tap.ipvs_id
1996: AND tap.id = tpl.tap_id

Line 2625: FROM OKL_TXL_AP_INV_LNS_B TPL,

2621: TPL.ATTRIBUTE15,
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';

Line 2629: AND DSTRS.SOURCE_TABLE = 'OKL_TXL_AP_INV_LNS_B';

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:
2631:
2632: -----------------------------------------------------------------
2633: -- Fetch Ap Interface Sequence Number

Line 3058: ,okl_txl_ap_inv_lns_b tpl

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

Line 3066: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

3062: trunc(tap.date_invoiced) BETWEEN
3063: NVL(p_from_date,SYSDATE-10000) AND NVL(p_to_date, SYSDATE+10000)
3064: AND acc_db.cr_dr_flag (+) = 'D'
3065: AND acc_cr.cr_dr_flag (+) = 'C'
3066: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
3067: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
3068: AND tpl.id = acc_db.source_id (+)
3069: AND tpl.id = acc_cr.source_id (+)
3070: AND povs.vendor_site_id = tap.ipvs_id

Line 3067: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

3063: NVL(p_from_date,SYSDATE-10000) AND NVL(p_to_date, SYSDATE+10000)
3064: AND acc_db.cr_dr_flag (+) = 'D'
3065: AND acc_cr.cr_dr_flag (+) = 'C'
3066: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
3067: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
3068: AND tpl.id = acc_db.source_id (+)
3069: AND tpl.id = acc_cr.source_id (+)
3070: AND povs.vendor_site_id = tap.ipvs_id
3071: AND tap.id = tpl.tap_id

Line 3170: ,okl_txl_ap_inv_lns_b tpl

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

Line 3177: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

3173: AND trunc(tap.date_invoiced) BETWEEN
3174: NVL(p_from_date,SYSDATE-10000) AND NVL(p_to_date, SYSDATE+10000)
3175: AND acc_db.cr_dr_flag (+) = 'D'
3176: AND acc_cr.cr_dr_flag (+) = 'C'
3177: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
3178: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
3179: AND tpl.id = acc_db.source_id (+)
3180: AND tpl.id = acc_cr.source_id (+)
3181: AND povs.vendor_site_id = tap.ipvs_id

Line 3178: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'

3174: NVL(p_from_date,SYSDATE-10000) AND NVL(p_to_date, SYSDATE+10000)
3175: AND acc_db.cr_dr_flag (+) = 'D'
3176: AND acc_cr.cr_dr_flag (+) = 'C'
3177: AND acc_db.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
3178: AND acc_cr.source_table (+)= 'OKL_TXL_AP_INV_LNS_B'
3179: AND tpl.id = acc_db.source_id (+)
3180: AND tpl.id = acc_cr.source_id (+)
3181: AND povs.vendor_site_id = tap.ipvs_id
3182: AND tap.id = tpl.tap_id