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.CSP_PARTS_ORDER dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1285: HZ_CUST_ACCT_SITES_ALL cust_acct,

1281: -- Get site_use_id for the inventory location id
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

Line 1296: FROM HZ_CUST_ACCT_SITES_ALL cust_acct2,

1292: CURSOR get_cust_site_id IS
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

Line 1309: HZ_CUST_ACCT_SITES_ALL cust_acct

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;
1313:

Line 1318: FROM HZ_CUST_ACCT_SITES_ALL cust_acct2

1314: CURSOR get_cust_site_id2 IS
1315: SELECT cust_acct.cust_acct_site_id,
1316: pol.customer_id,
1317: (SELECT cust_acct2.party_site_id
1318: FROM HZ_CUST_ACCT_SITES_ALL cust_acct2
1319: WHERE cust_acct2.party_site_id = cust_acct.party_site_id
1320: AND cust_acct2.org_id = l_source_operating_unit
1321: AND cust_acct2.cust_account_id = cust_acct.cust_account_id
1322: AND cust_acct2.status = 'A'

Line 1326: FROM HZ_CUST_ACCT_SITES_ALL cust_acct2

1322: AND cust_acct2.status = 'A'
1323: ),
1324: pol.org_id,
1325: (SELECT cust_acct2.cust_acct_site_id
1326: FROM HZ_CUST_ACCT_SITES_ALL cust_acct2
1327: WHERE cust_acct2.party_site_id = cust_acct.party_site_id
1328: AND cust_acct2.org_id = l_source_operating_unit
1329: AND cust_acct2.cust_account_id = cust_acct.cust_account_id
1330: )

Line 1333: HZ_CUST_ACCT_SITES_ALL cust_acct

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;
1337:

Line 1356: HZ_CUST_ACCT_SITES_ALL cust_acct

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
1360: AND cust_acct.org_id = l_source_operating_unit

Line 1368: (select hsa.cust_acct_site_id from HZ_CUST_ACCT_SITES_ALL hsa

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)
1372: and site_use_code = 'BILL_TO'

Line 1412: HZ_CUST_ACCT_SITES_ALL orgs,

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'
1416: and orgu.site_use_id = v_ship_bill_site

Line 1414: HZ_CUST_ACCT_SITES_ALL news

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
1418: and news.party_site_id = orgs.party_site_id

Line 1487: FROM HZ_CUST_ACCT_SITES_ALL cust_acct,

1483:
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

Line 1523: FROM HZ_CUST_ACCT_SITES_ALL cust_acct,

1519: new_user VARCHAR2(240);
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

Line 1552: HZ_CUST_ACCT_SITES_all ADDR

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
1556: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'