APPS.CSP_PARTS_ORDER dependencies on HZ_CUST_SITE_USES_ALL

Line 1286: HZ_CUST_SITE_USES_ALL site_use

1282: CURSOR cust_site_cur IS
1283: SELECT pol.customer_id, pol.site_use_id, cust_acct.cust_account_id
1284: FROM PO_LOCATION_ASSOCIATIONS_ALL pol,
1285: HZ_CUST_ACCT_SITES_ALL cust_acct,
1286: HZ_CUST_SITE_USES_ALL site_use
1287: WHERE pol.location_id = l_header_rec.ship_to_location_id
1288: AND site_use.site_use_id = pol.site_use_id
1289: AND cust_acct.cust_acct_site_id = site_use.cust_acct_site_id
1290: AND pol.org_id = l_source_operating_unit;

Line 1297: HZ_CUST_SITE_USES_ALL site_use2

1293: SELECT cust_acct.cust_acct_site_id,
1294: pol.customer_id,
1295: (SELECT cust_acct2.party_site_id
1296: FROM HZ_CUST_ACCT_SITES_ALL cust_acct2,
1297: HZ_CUST_SITE_USES_ALL site_use2
1298: WHERE cust_acct2.party_site_id = cust_acct.party_site_id
1299: AND cust_acct2.org_id = l_source_operating_unit
1300: AND cust_acct2.cust_account_id = cust_acct.cust_account_id
1301: AND cust_acct2.cust_acct_site_id = site_use2.cust_acct_site_id

Line 1308: HZ_CUST_SITE_USES_ALL site_use,

1304: AND cust_acct2.status = 'A'
1305: ),
1306: pol.org_id
1307: FROM PO_LOCATION_ASSOCIATIONS_ALL pol,
1308: HZ_CUST_SITE_USES_ALL site_use,
1309: HZ_CUST_ACCT_SITES_ALL cust_acct
1310: WHERE pol.location_id = l_header_rec.ship_to_location_id
1311: AND pol.site_use_id = site_use.site_use_id
1312: AND site_use.cust_acct_site_id = cust_acct.cust_acct_site_id;

Line 1332: HZ_CUST_SITE_USES_ALL site_use,

1328: AND cust_acct2.org_id = l_source_operating_unit
1329: AND cust_acct2.cust_account_id = cust_acct.cust_account_id
1330: )
1331: FROM PO_LOCATION_ASSOCIATIONS_ALL pol,
1332: HZ_CUST_SITE_USES_ALL site_use,
1333: HZ_CUST_ACCT_SITES_ALL cust_acct
1334: WHERE pol.location_id = l_header_rec.ship_to_location_id
1335: AND pol.site_use_id = site_use.site_use_id
1336: AND site_use.cust_acct_site_id = cust_acct.cust_acct_site_id;

Line 1355: HZ_CUST_SITE_USES_ALL site_use,

1351: select
1352: cust_acct.cust_acct_site_id,
1353: site_use.site_use_id
1354: from
1355: HZ_CUST_SITE_USES_ALL site_use,
1356: HZ_CUST_ACCT_SITES_ALL cust_acct
1357: where
1358: cust_acct.party_site_id = l_party_site_id
1359: -- AND cust_acct.cust_account_id = l_customer_id -- bug # 12545721

Line 1367: select site_use_id, cust_acct_site_id from HZ_CUST_SITE_USES_ALL where cust_acct_site_id in

1363: AND site_use.status = 'A'
1364: AND rownum = 1;
1365:
1366: cursor get_primary_bill_to (p_operating_unit number) is
1367: select site_use_id, cust_acct_site_id from HZ_CUST_SITE_USES_ALL where cust_acct_site_id in
1368: (select hsa.cust_acct_site_id from HZ_CUST_ACCT_SITES_ALL hsa
1369: where hsa.cust_account_id = l_cust_acct_id
1370: and hsa.status = 'A'
1371: and hsa.org_id = p_operating_unit)

Line 1381: FROM hz_cust_site_uses_all

1377: v_primary_bill_site_id number;
1378:
1379: cursor get_cust_acct_site_uses is
1380: SELECT site_use_id
1381: FROM hz_cust_site_uses_all
1382: WHERE cust_acct_site_id = l_cust_site_id
1383: AND status = 'A'
1384: AND site_use_code NOT IN
1385: (SELECT site_use_code

Line 1386: FROM hz_cust_site_uses_all

1382: WHERE cust_acct_site_id = l_cust_site_id
1383: AND status = 'A'
1384: AND site_use_code NOT IN
1385: (SELECT site_use_code
1386: FROM hz_cust_site_uses_all
1387: WHERE cust_acct_site_id = x_cust_acct_site_id
1388: AND status = 'A'
1389: );
1390:

Line 1405: from HZ_CUST_SITE_USES_ALL

1401: v_pri_bill_cust_prf_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1402:
1403: cursor get_bill_site_id is
1404: select cust_acct_site_id
1405: from HZ_CUST_SITE_USES_ALL
1406: where site_use_code = 'BILL_TO'
1407: and site_use_id = v_ship_bill_site;
1408:
1409: cursor check_bill_to_location is

Line 1411: from HZ_CUST_SITE_USES_ALL orgu,

1407: and site_use_id = v_ship_bill_site;
1408:
1409: cursor check_bill_to_location is
1410: select newu.site_use_id
1411: from HZ_CUST_SITE_USES_ALL orgu,
1412: HZ_CUST_ACCT_SITES_ALL orgs,
1413: HZ_CUST_SITE_USES_ALL newu,
1414: HZ_CUST_ACCT_SITES_ALL news
1415: where orgu.site_use_code = 'BILL_TO'

Line 1413: HZ_CUST_SITE_USES_ALL newu,

1409: cursor check_bill_to_location is
1410: select newu.site_use_id
1411: from HZ_CUST_SITE_USES_ALL orgu,
1412: HZ_CUST_ACCT_SITES_ALL orgs,
1413: HZ_CUST_SITE_USES_ALL newu,
1414: HZ_CUST_ACCT_SITES_ALL news
1415: where orgu.site_use_code = 'BILL_TO'
1416: and orgu.site_use_id = v_ship_bill_site
1417: and orgu.cust_acct_site_id = orgs.cust_acct_site_id

Line 1429: from hz_cust_site_uses_all

1425:
1426: /*
1427: cursor get_bill_acct_site_uses is
1428: select site_use_id
1429: from hz_cust_site_uses_all
1430: where cust_acct_site_id = v_bill_site_id
1431: and site_use_id = v_ship_bill_site;
1432: */
1433:

Line 1488: HZ_CUST_SITE_USES_ALL site_use,

1484: -- bug # 6471559
1485: cursor get_bill_to_for_sr (p_rqmt_header_id NUMBER) IS
1486: SELECT site_use.site_use_id, cia.ship_to_contact_id, cia.bill_to_contact_id
1487: FROM HZ_CUST_ACCT_SITES_ALL cust_acct,
1488: HZ_CUST_SITE_USES_ALL site_use,
1489: hz_party_site_uses hpsu,
1490: cs_incidents_all cia,
1491: csp_requirement_headers_v req
1492: WHERE req.requirement_header_id = p_rqmt_header_id

Line 1524: HZ_CUST_SITE_USES_ALL site_use,

1520:
1521: cursor c_sr_src_bill_to (v_rqmt_header_id NUMBER, v_src_org_id number) is
1522: SELECT site_use.site_use_id
1523: FROM HZ_CUST_ACCT_SITES_ALL cust_acct,
1524: HZ_CUST_SITE_USES_ALL site_use,
1525: hz_party_site_uses hpsu,
1526: cs_incidents_all cia,
1527: csp_requirement_headers_v req
1528: WHERE req.requirement_header_id = v_rqmt_header_id

Line 1551: HZ_CUST_SITE_USES_ALL SITE_USE,

1547: cursor get_valid_contact_id (v_party_id number, v_org_id number) is
1548: SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID
1549: FROM
1550: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1551: HZ_CUST_SITE_USES_ALL SITE_USE,
1552: HZ_CUST_ACCT_SITES_all ADDR
1553: WHERE
1554: ACCT_ROLE.party_id = v_party_id
1555: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID