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_K_LINE_FIN_EXT_PVT dependencies on PO_VENDORS

Line 1643: po_vendors pov,

1639: row_number() over ( partition by inv.cle_id
1640: order by inv.id desc, inv.invoice_number nulls last ) inv_row_num
1641: FROM okl_supp_invoice_dtls inv,
1642: okc_k_party_roles_b cpl,
1643: po_vendors pov,
1644: okc_k_lines_b cle,
1645: hz_locations hl,
1646: hz_party_sites hps,
1647: hz_cust_acct_sites_all cas,

Line 1677: PO_VENDORS POV,

1673: FROM
1674: OKC_K_ITEMS CIM_FEE,
1675: OKL_STRM_TYPE_TL STYT,
1676: OKC_K_PARTY_ROLES_B CPLB_FEE,
1677: PO_VENDORS POV,
1678: OKC_RULE_GROUPS_B RGP_LAFEXP,
1679: OKC_RULES_B RUL_LAFREQ,
1680: OKC_RULES_B RUL_LAFEXP,
1681: OKL_TIME_UNITS_V TUOM

Line 2259: -- p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID

2255: --there is no ID defined in the value set OKS_CUSTOMER_NUMBER. value is 'party_number'.
2256: AND cust_party.PARTY_NUMBER like nvl(P_CUSTOMER_NUMBER, cust_party.PARTY_NUMBER)
2257: -- P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS
2258: AND cust_party.party_id = nvl(P_CUSTOMER_NAME, cust_party.party_id)
2259: -- p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
2260: --Need nvl, as every contract may not have vendor_id (program vendor)
2261: AND ( nvl(fee_line.FEE_SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(fee_line.FEE_SUPPLIER_ID,-9999))
2262: OR nvl(supplier.SUPPLIER_VENDOR_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(supplier.SUPPLIER_VENDOR_ID,-9999))
2263: OR nvl(service_k_line.SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(service_k_line.SUPPLIER_ID,-9999))

Line 2265: -- P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID

2261: AND ( nvl(fee_line.FEE_SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(fee_line.FEE_SUPPLIER_ID,-9999))
2262: OR nvl(supplier.SUPPLIER_VENDOR_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(supplier.SUPPLIER_VENDOR_ID,-9999))
2263: OR nvl(service_k_line.SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(service_k_line.SUPPLIER_ID,-9999))
2264: )
2265: -- P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID
2266: AND ( nvl(fee_line.FEE_SUPPLIER_ID,-9999) = nvl(P_VENDOR_NAME,nvl(fee_line.FEE_SUPPLIER_ID,-9999))
2267: OR nvl(supplier.SUPPLIER_VENDOR_ID,-9999) = nvl(P_VENDOR_NAME,nvl(supplier.SUPPLIER_VENDOR_ID,-9999))
2268: OR nvl(service_k_line.SUPPLIER_ID,-9999) = nvl(P_VENDOR_NAME,nvl(service_k_line.SUPPLIER_ID,-9999))
2269: )

Line 3754: po_vendors pov,

3750: row_number() over ( partition by inv.cle_id
3751: order by inv.id desc, inv.invoice_number nulls last ) inv_row_num
3752: FROM okl_supp_invoice_dtls inv,
3753: okc_k_party_roles_b cpl,
3754: po_vendors pov,
3755: okc_k_lines_b cle,
3756: hz_locations hl,
3757: hz_party_sites hps,
3758: hz_cust_acct_sites_all cas,

Line 3788: PO_VENDORS POV,

3784: FROM
3785: OKC_K_ITEMS CIM_FEE,
3786: OKL_STRM_TYPE_TL STYT,
3787: OKC_K_PARTY_ROLES_B CPLB_FEE,
3788: PO_VENDORS POV,
3789: OKC_RULE_GROUPS_B RGP_LAFEXP,
3790: OKC_RULES_B RUL_LAFREQ,
3791: OKC_RULES_B RUL_LAFEXP,
3792: OKL_TIME_UNITS_V TUOM

Line 4318: -- p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID

4314: --there is no ID defined in the value set OKS_CUSTOMER_NUMBER. value is 'party_number'.
4315: AND cust_party.PARTY_NUMBER like nvl(P_CUSTOMER_NUMBER, cust_party.PARTY_NUMBER)
4316: -- P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS
4317: AND cust_party.party_id = nvl(P_CUSTOMER_NAME, cust_party.party_id)
4318: -- p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
4319: --Need nvl, as every contract may not have vendor_id (program vendor)
4320: AND ( nvl(fee_line.FEE_SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(fee_line.FEE_SUPPLIER_ID,-9999))
4321: OR nvl(supplier.SUPPLIER_VENDOR_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(supplier.SUPPLIER_VENDOR_ID,-9999))
4322: OR nvl(service_k_line.SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(service_k_line.SUPPLIER_ID,-9999))

Line 4324: -- P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID

4320: AND ( nvl(fee_line.FEE_SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(fee_line.FEE_SUPPLIER_ID,-9999))
4321: OR nvl(supplier.SUPPLIER_VENDOR_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(supplier.SUPPLIER_VENDOR_ID,-9999))
4322: OR nvl(service_k_line.SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(service_k_line.SUPPLIER_ID,-9999))
4323: )
4324: -- P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID
4325: AND ( nvl(fee_line.FEE_SUPPLIER_ID,-9999) = nvl(P_VENDOR_NAME,nvl(fee_line.FEE_SUPPLIER_ID,-9999))
4326: OR nvl(supplier.SUPPLIER_VENDOR_ID,-9999) = nvl(P_VENDOR_NAME,nvl(supplier.SUPPLIER_VENDOR_ID,-9999))
4327: OR nvl(service_k_line.SUPPLIER_ID,-9999) = nvl(P_VENDOR_NAME,nvl(service_k_line.SUPPLIER_ID,-9999))
4328: )

Line 5735: po_vendors pov,

5731: row_number() over ( partition by inv.cle_id
5732: order by inv.id desc, inv.invoice_number nulls last ) inv_row_num
5733: FROM okl_supp_invoice_dtls inv,
5734: okc_k_party_roles_b cpl,
5735: po_vendors pov,
5736: okc_k_lines_b cle,
5737: hz_locations hl,
5738: hz_party_sites hps,
5739: hz_cust_acct_sites_all cas,

Line 5769: PO_VENDORS POV,

5765: FROM
5766: OKC_K_ITEMS CIM_FEE,
5767: OKL_STRM_TYPE_TL STYT,
5768: OKC_K_PARTY_ROLES_B CPLB_FEE,
5769: PO_VENDORS POV,
5770: OKC_RULE_GROUPS_B RGP_LAFEXP,
5771: OKC_RULES_B RUL_LAFREQ,
5772: OKC_RULES_B RUL_LAFEXP,
5773: OKL_TIME_UNITS_V TUOM

Line 6234: -- p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID

6230: --there is no ID defined in the value set OKS_CUSTOMER_NUMBER. value is 'party_number'.
6231: AND cust_party.PARTY_NUMBER like nvl(P_CUSTOMER_NUMBER, cust_party.PARTY_NUMBER)
6232: -- P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS
6233: AND cust_party.party_id = nvl(P_CUSTOMER_NAME, cust_party.party_id)
6234: -- p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
6235: --Need nvl, as every contract may not have vendor_id (program vendor)
6236: AND ( nvl(fee_line.FEE_SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(fee_line.FEE_SUPPLIER_ID,-9999))
6237: OR nvl(supplier.SUPPLIER_VENDOR_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(supplier.SUPPLIER_VENDOR_ID,-9999))
6238: OR nvl(service_k_line.SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(service_k_line.SUPPLIER_ID,-9999))

Line 6240: -- P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID

6236: AND ( nvl(fee_line.FEE_SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(fee_line.FEE_SUPPLIER_ID,-9999))
6237: OR nvl(supplier.SUPPLIER_VENDOR_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(supplier.SUPPLIER_VENDOR_ID,-9999))
6238: OR nvl(service_k_line.SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(service_k_line.SUPPLIER_ID,-9999))
6239: )
6240: -- P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID
6241: AND ( nvl(fee_line.FEE_SUPPLIER_ID,-9999) = nvl(P_VENDOR_NAME,nvl(fee_line.FEE_SUPPLIER_ID,-9999))
6242: OR nvl(supplier.SUPPLIER_VENDOR_ID,-9999) = nvl(P_VENDOR_NAME,nvl(supplier.SUPPLIER_VENDOR_ID,-9999))
6243: OR nvl(service_k_line.SUPPLIER_ID,-9999) = nvl(P_VENDOR_NAME,nvl(service_k_line.SUPPLIER_ID,-9999))
6244: )