DBA Data[Home] [Help]

APPS.OKE_FORM_DD250 dependencies on OKE_CUST_SITE_USES_V

Line 664: FROM oke_cust_site_uses_v

660: rpad(nvl(Country,' ') , 80 , ' ') /* Country_Code */
661: Address
662: , Location_ID
663: , Site_Use_Code
664: FROM oke_cust_site_uses_v
665: WHERE ID1 = C_Site_ID;
666:
667: ContractorAddrRec OrgAddr%RowType;
668: AdminByAddrRec CustSiteAddr%RowType;

Line 817: FROM oke_cust_site_uses_v

813:
814: CURSOR ShipTo
815: ( C_Ship_To_Loc NUMBER ) IS
816: SELECT ID1
817: FROM oke_cust_site_uses_v
818: WHERE location_id = C_Ship_To_Loc
819: AND site_use_code = 'SHIP_TO';
820:
821: ShipToLoc ShipTo%RowType;