DBA Data[Home] [Help]

APPS.OE_ITORD_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 521: FROM hz_cust_site_uses_all site

517: ELSE
518: begin
519: SELECT 'Y'
520: INTO l_exists
521: FROM hz_cust_site_uses_all site
522: WHERE site.site_use_code = 'SHIP_TO'
523: AND site.site_use_id= p_Item_Orderability_Import_Rec.SHIP_TO_LOCATION_ID;
524: Exception
525: when no_data_found then

Line 682: FROM hz_cust_site_uses_all site

678: ELSE
679: begin
680: SELECT 'Y'
681: INTO l_exists
682: FROM hz_cust_site_uses_all site
683: WHERE site.site_use_code = 'BILL_TO'
684: AND site.site_use_id= p_Item_Orderability_Import_Rec.BILL_TO_LOCATION_ID ;
685: Exception
686: when no_data_found then

Line 724: FROM hz_cust_site_uses_all site

720:
721: begin
722: SELECT 'Y'
723: INTO l_exists
724: FROM hz_cust_site_uses_all site
725: WHERE site.site_use_code = 'DELIVER_TO'
726: AND site.site_use_id= p_Item_Orderability_Import_Rec.DELIVER_TO_LOCATION_ID;
727: Exception
728: when no_data_found then