APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on HZ_PARTIES

Line 1058: HZ_PARTIES cust_party,

1054: OKC_STATUSES_B status,
1055: OKC_STATUSES_TL status_tl,
1056: OKC_K_PARTY_ROLES_B cust_party_roles,
1057: fnd_lookup_values_vl lookup_book_class,
1058: HZ_PARTIES cust_party,
1059: HZ_CUST_ACCOUNTS cust_accounts,
1060: OKL_PRODUCTS pdt,
1061: OKL_PRODUCTS rpt_pdt,
1062: OKC_K_HEADERS_ALL_B vendor_chr,

Line 1190: --sechawla : P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS

1186:
1187: --there is no ID defined in the value set OKS_CUSTOMER_NUMBER. value is 'party_number'.
1188: AND cust_party.PARTY_NUMBER like nvl(P_CUSTOMER_NUMBER, cust_party.PARTY_NUMBER)
1189:
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

Line 2088: HZ_PARTIES cust_party,

2084: OKC_STATUSES_TL status_tl,
2085: OKC_K_PARTY_ROLES_B cust_party_roles,
2086: fnd_lookup_values_vl lookup_book_class,
2087:
2088: HZ_PARTIES cust_party,
2089: HZ_CUST_ACCOUNTS cust_accounts,
2090: OKL_PRODUCTS pdt,
2091: OKL_PRODUCTS rpt_pdt,
2092: OKC_K_HEADERS_ALL_B vendor_chr,

Line 2222: --sechawla : P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS

2218:
2219: --there is no ID defined in the value set OKS_CUSTOMER_NUMBER. value is 'party_number'.
2220: AND cust_party.PARTY_NUMBER like nvl(P_CUSTOMER_NUMBER, cust_party.PARTY_NUMBER)
2221:
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