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 1642: po_vendors pov,

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

Line 1676: PO_VENDORS POV,

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

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

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

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

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

Line 3753: po_vendors pov,

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

Line 3787: PO_VENDORS POV,

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

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

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

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

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

Line 5734: po_vendors pov,

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

Line 5768: PO_VENDORS POV,

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

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

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

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

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