DBA Data[Home] [Help]

APPS.OE_ITORD_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 558: FROM hz_cust_site_uses_all site

554: ELSE
555: begin
556: SELECT 'Y'
557: INTO l_exists
558: FROM hz_cust_site_uses_all site
559: WHERE site.site_use_code = 'SHIP_TO'
560: AND site.site_use_id= p_Item_Orderability_Import_Rec.SHIP_TO_LOCATION_ID;
561: Exception
562: when no_data_found then

Line 719: FROM hz_cust_site_uses_all site

715: ELSE
716: begin
717: SELECT 'Y'
718: INTO l_exists
719: FROM hz_cust_site_uses_all site
720: WHERE site.site_use_code = 'BILL_TO'
721: AND site.site_use_id= p_Item_Orderability_Import_Rec.BILL_TO_LOCATION_ID ;
722: Exception
723: when no_data_found then

Line 761: FROM hz_cust_site_uses_all site

757:
758: begin
759: SELECT 'Y'
760: INTO l_exists
761: FROM hz_cust_site_uses_all site
762: WHERE site.site_use_code = 'DELIVER_TO'
763: AND site.site_use_id= p_Item_Orderability_Import_Rec.DELIVER_TO_LOCATION_ID;
764: Exception
765: when no_data_found then