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

Line 1066: po_vendors vendor,

1062: OKC_K_HEADERS_ALL_B vendor_chr,
1063:
1064: okc_rule_groups_b rgd,
1065: okc_k_party_roles_v cpl,
1066: po_vendors vendor,
1067: OKL_SYS_ACCT_OPTS_ALL acct_sys_opts,
1068: GL_LEDGERS ledger,
1069: okc_contacts sales_rep_contact,
1070: okx_salesreps_v sales_rep,

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

1190: --sechawla : P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS
1191: AND cust_party.party_id = nvl(P_CUSTOMER_NAME, cust_party.party_id)
1192: AND nvl(cust_party.SIC_CODE,'XXX') like nvl(P_SIC_CODE, nvl(cust_party.SIC_CODE,'XXX'))
1193:
1194: --sechawla : p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
1195: --Need nvl, as every contract may not have vendor_id (program vendor)
1196: AND nvl(vendor.vendor_id,-9999) = nvl(P_VENDOR_NUMBER,nvl(vendor.vendor_id,-9999))
1197:
1198: --sechawla : P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID

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

1194: --sechawla : p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
1195: --Need nvl, as every contract may not have vendor_id (program vendor)
1196: AND nvl(vendor.vendor_id,-9999) = nvl(P_VENDOR_NUMBER,nvl(vendor.vendor_id,-9999))
1197:
1198: --sechawla : P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID
1199: AND nvl(vendor.vendor_id,-9999) = nvl(P_VENDOR_NAME,nvl(vendor.vendor_id,-9999))
1200:
1201: -- P_SALES_CHANNEL -> value set QP_SALES_CHANNEL_CODE -> returns oe_lookups.lookup_code
1202: AND nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX') like nvl(P_SALES_CHANNEL, nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX'))

Line 2096: po_vendors vendor,

2092: OKC_K_HEADERS_ALL_B vendor_chr,
2093:
2094: okc_rule_groups_b rgd,
2095: okc_k_party_roles_v cpl,
2096: po_vendors vendor,
2097: OKL_SYS_ACCT_OPTS_ALL acct_sys_opts,
2098: GL_LEDGERS ledger,
2099: okc_contacts sales_rep_contact,
2100: okx_salesreps_v sales_rep,

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

2222: --sechawla : P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS
2223: AND cust_party.party_id = nvl(P_CUSTOMER_NAME, cust_party.party_id)
2224: AND nvl(cust_party.SIC_CODE,'XXX') like nvl(P_SIC_CODE, nvl(cust_party.SIC_CODE,'XXX'))
2225:
2226: --sechawla : p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
2227: --Need nvl, as every contract may not have vendor_id (program vendor)
2228: AND nvl(vendor.vendor_id,-9999) = nvl(P_VENDOR_NUMBER,nvl(vendor.vendor_id,-9999))
2229:
2230: --sechawla : P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID

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

2226: --sechawla : p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
2227: --Need nvl, as every contract may not have vendor_id (program vendor)
2228: AND nvl(vendor.vendor_id,-9999) = nvl(P_VENDOR_NUMBER,nvl(vendor.vendor_id,-9999))
2229:
2230: --sechawla : P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID
2231: AND nvl(vendor.vendor_id,-9999) = nvl(P_VENDOR_NAME,nvl(vendor.vendor_id,-9999))
2232:
2233: -- P_SALES_CHANNEL -> value set QP_SALES_CHANNEL_CODE -> returns oe_lookups.lookup_code
2234: AND nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX') like nvl(P_SALES_CHANNEL, nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX'))