[Home] [Help]
208: CURSOR party_sites_cur(p_party_id VARCHAR2, p_site_name VARCHAR2)
209: IS
210: SELECT PSE.PARTY_SITE_ID ID1
211: FROM OKC_K_PARTY_ROLES_B rle,
212: OKC_K_HEADERS_ALL_V hdr1,
213: okc_k_items itm,
214: HZ_PARTY_SITES PSE,
215: HZ_LOCATIONS LCN
216: WHERE rle.jtot_object1_code ='OKX_PARTY'
229: CURSOR party_items_cur(p_party_id VARCHAR2, p_item_name VARCHAR2)
230: IS
231: SELECT B.INVENTORY_ITEM_ID ID1
232: FROM OKC_K_PARTY_ROLES_B rle,
233: OKC_K_HEADERS_ALL_V hdr1,
234: okc_k_items itm,
235: MTL_SYSTEM_ITEMS_B_KFV B,
236: MTL_SYSTEM_ITEMS_TL T
237: WHERE rle.jtot_object1_code='OKX_PARTY'
252: CURSOR party_systems_cur(p_party_id VARCHAR2, p_system_name VARCHAR2)
253: IS
254: SELECT B.SYSTEM_ID ID1
255: FROM OKC_K_PARTY_ROLES_B rle,
256: OKC_K_HEADERS_ALL_V hdr1,
257: okc_k_items itm,
258: CS_SYSTEMS_ALL_B B,
259: CS_SYSTEMS_ALL_TL T
260: WHERE rle.jtot_object1_code='OKX_PARTY'
536: PSE.PARTY_SITE_NAME NAME,
537: SUBSTR(arp_addr_label_pkg.format_address(NULL,LCN.ADDRESS1,LCN.ADDRESS2,LCN.ADDRESS3,LCN.ADDRESS4,
538: LCN.CITY,LCN.COUNTY,LCN.STATE,LCN.PROVINCE,LCN.POSTAL_CODE,NULL,LCN.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),1,80) DESCRIPTION
539: FROM OKC_K_PARTY_ROLES_B rle,
540: OKC_K_HEADERS_ALL_V hdr1,
541: okc_k_items itm,
542: HZ_PARTY_SITES PSE,
543: HZ_LOCATIONS LCN
544: WHERE rle.jtot_object1_code = 'OKX_PARTY'
639: B.ORGANIZATION_ID ID2,
640: T.DESCRIPTION NAME,
641: B.CONCATENATED_SEGMENTS DESCRIPTION
642: FROM OKC_K_PARTY_ROLES_B rle,
643: OKC_K_HEADERS_ALL_V hdr1,
644: okc_k_items itm,
645: MTL_SYSTEM_ITEMS_B_KFV B,
646: MTL_SYSTEM_ITEMS_TL T
647: WHERE rle.jtot_object1_code='OKX_PARTY'
746: '#' ID2,
747: T.NAME NAME,
748: T.DESCRIPTION DESCRIPTION
749: FROM OKC_K_PARTY_ROLES_B rle,
750: OKC_K_HEADERS_ALL_V hdr1,
751: okc_k_items itm,
752: CS_SYSTEMS_ALL_B B,
753: CS_SYSTEMS_ALL_TL T
754: WHERE rle.jtot_object1_code='OKX_PARTY'
1058: )
1059: IS
1060: CURSOR contract_number_id_cur(p_contract_number VARCHAR2)
1061: IS
1062: SELECT id FROM OKC_K_HEADERS_ALL_V
1063: WHERE contract_number=p_contract_number
1064: AND contract_number_modifier IS NULL;
1065:
1066: CURSOR contract_num_mod_id_cur(p_contract_number VARCHAR2, p_contract_modifier VARCHAR2)
1064: AND contract_number_modifier IS NULL;
1065:
1066: CURSOR contract_num_mod_id_cur(p_contract_number VARCHAR2, p_contract_modifier VARCHAR2)
1067: IS
1068: SELECT id FROM OKC_K_HEADERS_ALL_V
1069: WHERE contract_number=p_contract_number
1070: AND contract_number_modifier=p_contract_modifier;
1071:
1072: l_contract_id NUMBER;
1271: OKX_ORDER_HEADERS_V ord,
1272: OKC_STATUSES_V sts,
1273: OKC_SUBCLASSES_V cat,
1274: OKC_K_VERS_NUMBERS_V ver,
1275: OKC_K_HEADERS_ALL_V hdr
1276: WHERE
1277: hdr.ID = to_number(p_contract_id_arg)
1278: AND hdr.sts_code = sts.code
1279: AND SYSDATE BETWEEN sts.start_date AND nvl(sts.end_date,SYSDATE)
1359: HZ_PARTY_SITES PS,
1360: HZ_LOCATIONS L,
1361: HZ_CUST_ACCT_SITES_ALL CA,
1362: OKX_CUSTOMER_ACCOUNTS_V cus_b,
1363: OKC_K_HEADERS_ALL_V hdr
1364: WHERE hdr.ID= p_contract_id
1365: AND CS.SITE_USE_ID = hdr.BILL_TO_SITE_USE_ID
1366: AND CS.SITE_USE_CODE = 'BILL_TO'
1367: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
1390: HZ_CUST_SITE_USES_ALL CS,
1391: HZ_PARTY_SITES PS,
1392: HZ_LOCATIONS L,
1393: HZ_CUST_ACCT_SITES_ALL CA,
1394: OKC_K_HEADERS_ALL_V hdr
1395: WHERE
1396: hdr.ID=p_contract_id
1397: AND CS.SITE_USE_ID = hdr.SHIP_TO_SITE_USE_ID
1398: AND CS.SITE_USE_CODE = 'SHIP_TO'