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 PO_LOCATION_ASSOCIATIONS_ALL

Line 1284: FROM PO_LOCATION_ASSOCIATIONS_ALL pol,

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

Line 1307: FROM PO_LOCATION_ASSOCIATIONS_ALL pol,

1303: AND site_use2.status = 'A'
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

Line 1331: FROM PO_LOCATION_ASSOCIATIONS_ALL pol,

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