[Home] [Help]
273: CURSOR party_products_cur(p_party_id VARCHAR2, p_product_name VARCHAR2)
274: IS
275: SELECT CP.INSTANCE_ID ID1
276: FROM OKC_K_PARTY_ROLES_B rle,
277: OKC_K_HEADERS_ALL_B hdr1,
278: okc_k_items itm,
279: CSI_ITEM_INSTANCES CP,
280: MTL_SYSTEM_ITEMS_B_KFV BK
281: WHERE rle.jtot_object1_code = 'OKX_PARTY'
851: '#' ID2,
852: BK.DESCRIPTION NAME,
853: BK.CONCATENATED_SEGMENTS || '-' || CP.instance_number DESCRIPTION
854: FROM OKC_K_PARTY_ROLES_B rle,
855: OKC_K_HEADERS_ALL_B hdr1,
856: OKC_K_ITEMS itm,
857: CSI_ITEM_INSTANCES CP,
858: MTL_SYSTEM_ITEMS_B_KFV BK
859: WHERE rle.jtot_object1_code = 'OKX_PARTY'
1304: HZ_PARTY_SITES PS,
1305: HZ_LOCATIONS L,
1306: HZ_CUST_ACCT_SITES_ALL CA,
1307: OKX_CUSTOMER_ACCOUNTS_V cus_b,
1308: OKC_K_HEADERS_ALL_B hdr,
1309: OKX_COUNTRIES_V okxCountry
1310: WHERE hdr.ID=p_contract_id
1311: AND CS.SITE_USE_ID = hdr.BILL_TO_SITE_USE_ID
1312: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
1324: HZ_PARTY_SITES PS,
1325: HZ_LOCATIONS L,
1326: HZ_CUST_ACCT_SITES_ALL CA,
1327: OKX_CUSTOMER_ACCOUNTS_V cus_b,
1328: OKC_K_HEADERS_ALL_B hdr,
1329: OKX_COUNTRIES_V okxCountry
1330: WHERE
1331: hdr.ID=p_contract_id
1332: AND CS.SITE_USE_ID = hdr.SHIP_TO_SITE_USE_ID
1419: FROM
1420: FND_LOOKUPS fnd,
1421: OKX_PARTIES_V pty,
1422: OKC_K_PARTY_ROLES_B rle,
1423: OKC_K_HEADERS_ALL_B hdr
1424: WHERE
1425: hdr.id=p_contract_id
1426: and rle.chr_id=hdr.id
1427: and rle.dnz_chr_id=hdr.id
1441: FROM
1442: FND_LOOKUPS fnd,
1443: OKX_PARTIES_V pty,
1444: OKC_K_PARTY_ROLES_B rle,
1445: OKC_K_HEADERS_ALL_B hdr
1446: WHERE
1447: hdr.id=p_contract_id
1448: AND rle.chr_id=hdr.id
1449: AND rle.dnz_chr_id=hdr.id
1463: FROM
1464: FND_LOOKUPS fnd,
1465: OKX_ORGANIZATION_DEFS_V pty,
1466: OKC_K_PARTY_ROLES_B rle,
1467: OKC_K_HEADERS_ALL_B hdr
1468: WHERE
1469: hdr.id=p_contract_id
1470: AND rle.chr_id=hdr.id
1471: AND rle.dnz_chr_id=hdr.id
2010: and con.CPL_ID = rol.ID;
2011:
2012: CURSOR get_org_id_cur(contract_id NUMBER) IS
2013: SELECT org_id
2014: FROM OKC_K_HEADERS_ALL_B
2015: WHERE id = contract_id;
2016:
2017: CURSOR salesrep_email_cur(p_org_id NUMBER,p_contact_id VARCHAR2) IS
2018: SELECT email_address
2220: ,L.COUNTY,L.STATE,L.PROVINCE,L.POSTAL_CODE,NULL,L.COUNTRY,NULL, NULL,NULL,NULL,NULL,NULL,NULL
2221: ,'N','N',300,1,1) Address
2222: From
2223: OKC_K_LINES_B okcLn,
2224: OKC_K_HEADERS_ALL_B hdr,
2225: HZ_CUST_SITE_USES_ALL CS,
2226: HZ_PARTY_SITES PS,
2227: HZ_LOCATIONS L,
2228: HZ_CUST_ACCT_SITES_ALL CA,
3668: CURSOR get_orgId(p_line_id VARCHAR2)
3669: IS
3670: Select hdr.org_id
3671: FROM okc_k_lines_b ln,
3672: okc_k_headers_All_b hdr
3673: WHERE ln.id = to_number(p_line_id)
3674: AND hdr.id = ln.dnz_chr_id;
3675:
3676: CURSOR usage_tax_cur(p_line_id_arg VARCHAR2)
3781: cgrp.SOURCE_OBJECT_CODE||';'||hdr.CONTRACT_NUMBER||';'||hdr.CONTRACT_NUMBER_MODIFIER SourceDetails,
3782: sys.DESCRIPTION Description
3783: From
3784: OKX_SYSTEM_ITEMS_V sys,
3785: OKC_K_HEADERS_ALL_B hdr,
3786: OKC_K_ITEMS_V itm,
3787: OKC_K_LINES_B ln,
3788: OKX_COUNTER_GROUPS_V cgrp,
3789: OKX_COUNTERS_V ct
3821: cca.SOURCE_OBJECT_CODE||';'||hdr.CONTRACT_NUMBER||';'||hdr.CONTRACT_NUMBER_MODIFIER SourceDetails,
3822: sys.DESCRIPTION Description
3823: From
3824: MTL_SYSTEM_ITEMS_B_KFV sys,
3825: OKC_K_HEADERS_ALL_B hdr,
3826: OKC_K_ITEMS itm,
3827: OKC_K_LINES_B ln,
3828: CS_CSI_COUNTER_GROUPS CCG,
3829: csi_counters_b ccb,
4010: FROM
4011: OKX_COUNTER_GROUPS_V CG ,
4012: OKX_COUNTERS_V CT ,
4013: OKC_K_LINES_B KL ,
4014: OKC_K_HEADERS_ALL_B KH
4015: WHERE
4016: CG.COUNTER_GROUP_ID = CT.COUNTER_GROUP_ID
4017: AND CT.USAGE_ITEM_ID IS NOT NULL
4018: AND CG.SOURCE_OBJECT_ID = KL.ID
4069: CSI_COUNTER_READINGS CV,
4070: csi_lookups lkup,
4071: OKC_K_ITEMS KI,
4072: OKC_K_LINES_B KL ,
4073: OKC_K_HEADERS_ALL_B KH
4074: WHERE sys.INVENTORY_ITEM_ID = KI.OBJECT1_ID1
4075: and sys.ORGANIZATION_ID = KI.OBJECT1_ID2
4076: AND ccg.template_flag = 'N'
4077: AND ccg.counter_group_id = ccb.group_id