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 1052: po_vendors vendor,

1048: OKC_K_HEADERS_ALL_B vendor_chr,
1049:
1050: okc_rule_groups_b rgd,
1051: okc_k_party_roles_v cpl,
1052: po_vendors vendor,
1053: OKL_SYS_ACCT_OPTS_ALL acct_sys_opts,
1054: GL_LEDGERS ledger,
1055: okc_contacts sales_rep_contact,
1056: okx_salesreps_v sales_rep,

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

1176: --sechawla : P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS
1177: AND cust_party.party_id = nvl(P_CUSTOMER_NAME, cust_party.party_id)
1178: AND nvl(cust_party.SIC_CODE,'XXX') like nvl(P_SIC_CODE, nvl(cust_party.SIC_CODE,'XXX'))
1179:
1180: --sechawla : p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
1181: --Need nvl, as every contract may not have vendor_id (program vendor)
1182: AND nvl(vendor.vendor_id,-9999) = nvl(P_VENDOR_NUMBER,nvl(vendor.vendor_id,-9999))
1183:
1184: --sechawla : P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID

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

1180: --sechawla : p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
1181: --Need nvl, as every contract may not have vendor_id (program vendor)
1182: AND nvl(vendor.vendor_id,-9999) = nvl(P_VENDOR_NUMBER,nvl(vendor.vendor_id,-9999))
1183:
1184: --sechawla : P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID
1185: AND nvl(vendor.vendor_id,-9999) = nvl(P_VENDOR_NAME,nvl(vendor.vendor_id,-9999))
1186:
1187: -- P_SALES_CHANNEL -> value set QP_SALES_CHANNEL_CODE -> returns oe_lookups.lookup_code
1188: AND nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX') like nvl(P_SALES_CHANNEL, nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX'))

Line 2082: po_vendors vendor,

2078: OKC_K_HEADERS_ALL_B vendor_chr,
2079:
2080: okc_rule_groups_b rgd,
2081: okc_k_party_roles_v cpl,
2082: po_vendors vendor,
2083: OKL_SYS_ACCT_OPTS_ALL acct_sys_opts,
2084: GL_LEDGERS ledger,
2085: okc_contacts sales_rep_contact,
2086: okx_salesreps_v sales_rep,

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

2208: --sechawla : P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS
2209: AND cust_party.party_id = nvl(P_CUSTOMER_NAME, cust_party.party_id)
2210: AND nvl(cust_party.SIC_CODE,'XXX') like nvl(P_SIC_CODE, nvl(cust_party.SIC_CODE,'XXX'))
2211:
2212: --sechawla : p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
2213: --Need nvl, as every contract may not have vendor_id (program vendor)
2214: AND nvl(vendor.vendor_id,-9999) = nvl(P_VENDOR_NUMBER,nvl(vendor.vendor_id,-9999))
2215:
2216: --sechawla : P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID

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

2212: --sechawla : p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
2213: --Need nvl, as every contract may not have vendor_id (program vendor)
2214: AND nvl(vendor.vendor_id,-9999) = nvl(P_VENDOR_NUMBER,nvl(vendor.vendor_id,-9999))
2215:
2216: --sechawla : P_VENDOR_NAME -> value set OKL_VENDORS -> returns PO_VENDORS.VENDOR_ID
2217: AND nvl(vendor.vendor_id,-9999) = nvl(P_VENDOR_NAME,nvl(vendor.vendor_id,-9999))
2218:
2219: -- P_SALES_CHANNEL -> value set QP_SALES_CHANNEL_CODE -> returns oe_lookups.lookup_code
2220: AND nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX') like nvl(P_SALES_CHANNEL, nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX'))