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.CSI_ORDER_SHIP_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 619: hz_cust_site_uses_all u

615:
616: SELECT party_site_id
617: INTO l_party_site_id
618: FROM hz_cust_acct_sites_all c,
619: hz_cust_site_uses_all u
620: WHERE c.cust_acct_site_id = u.cust_acct_site_id
621: AND u.site_use_id = l_order_line_rec.ib_current_loc_id;
622:
623: -- Re-assigning party site id fetched from the above block

Line 643: hz_cust_site_uses_all u

639: BEGIN
640: SELECT party_site_id
641: INTO l_party_install_site_id
642: FROM hz_cust_acct_sites_all c,
643: hz_cust_site_uses_all u
644: WHERE c.cust_acct_site_id = u.cust_acct_site_id
645: AND u.site_use_id = l_order_line_rec.ib_install_loc_id;
646:
647: l_order_line_rec.ib_install_loc_id := l_party_install_site_id;

Line 4301: FROM hz_cust_site_uses_all HCSU,

4297: BEGIN
4298:
4299: SELECT HCAS.party_site_id
4300: INTO l_party_site_id
4301: FROM hz_cust_site_uses_all HCSU,
4302: hz_cust_acct_sites_all HCAS
4303: WHERE HCSU.site_use_id = l_order_line_rec.ship_to_org_id
4304: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
4305:

Line 5586: hz_cust_site_uses_all u

5582:
5583: SELECT party_site_id
5584: INTO l_party_site_id
5585: FROM hz_cust_acct_sites_all c,
5586: hz_cust_site_uses_all u
5587: WHERE c.cust_acct_site_id = u.cust_acct_site_id
5588: AND u.site_use_id = p_order_line_rec.ib_current_loc_id; -- ship_to_org_id;
5589:
5590: EXCEPTION

Line 5616: hz_cust_site_uses_all u

5612:
5613: SELECT party_site_id
5614: INTO l_install_party_site_id
5615: FROM hz_cust_acct_sites_all c,
5616: hz_cust_site_uses_all u
5617: WHERE c.cust_acct_site_id = u.cust_acct_site_id
5618: AND u.site_use_id = p_order_line_rec.ib_install_loc_id; -- ship_to_org_id;
5619:
5620: EXCEPTION

Line 5998: FROM hz_cust_site_uses_all HCSU,

5994: THEN
5995: BEGIN
5996: SELECT HCAS.party_site_id
5997: INTO l_upd_party_site_id
5998: FROM hz_cust_site_uses_all HCSU,
5999: hz_cust_acct_sites_all HCAS
6000: WHERE HCSU.site_use_id = p_order_line_rec.ib_install_loc_id
6001: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
6002:

Line 6811: FROM hz_cust_site_uses_all HCSU,

6807: THEN
6808: BEGIN
6809: SELECT HCAS.party_site_id
6810: INTO l_cre_party_site_id
6811: FROM hz_cust_site_uses_all HCSU,
6812: hz_cust_acct_sites_all HCAS
6813: WHERE HCSU.site_use_id = p_order_line_rec.ib_install_loc_id
6814: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
6815:

Line 8347: hz_cust_site_uses_all u

8343: BEGIN
8344: SELECT party_site_id
8345: INTO l_party_site_id
8346: FROM hz_cust_acct_sites_all c,
8347: hz_cust_site_uses_all u
8348: WHERE c.cust_acct_site_id = u.cust_acct_site_id
8349: AND u.site_use_id = x_order_shipment_tbl(i).ib_current_loc_id; -- ship_to_org_id;
8350: Exception
8351: When no_data_found then

Line 8375: hz_cust_site_uses_all u

8371: BEGIN
8372: SELECT party_site_id
8373: INTO l_install_party_site_id
8374: FROM hz_cust_acct_sites_all c,
8375: hz_cust_site_uses_all u
8376: WHERE c.cust_acct_site_id = u.cust_acct_site_id
8377: AND u.site_use_id = x_order_shipment_tbl(i).ib_install_loc_id; -- ship_to_org_id;
8378: Exception
8379: When no_data_found then