APPS.MST_SNAPSHOT_TASK_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

select lo.owner_type, lo.OWNER_PARTY_ID
from wsh_location_owners lo
where lo.wsh_location_id = lLocationId;

Line: 12

select hzc.CUST_ACCOUNT_ID
from hz_cust_accounts hzc
where party_id = lownerId
and rownum = 1;

Line: 18

select hzpr.OBJECT_ID
from hz_relationships hzpr
where hzpr.SUBJECT_ID = lownerId
and hzpr.RELATIONSHIP_CODE = 'POS_VENDOR_PARTY'
 and  hzpr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
 AND  hzpr.OBJECT_TABLE_NAME = 'HZ_PARTIES'
 AND  hzpr.DIRECTIONAL_FLAG = 'F'
and rownum = 1;

Line: 28

   select assg.CALENDAR_CODE
   from wsh_calendar_assignments assg
   WHERE
     CALENDAR_TYPE = lCalendarType    --'SHIPPING' or 'RECEIVING'
     AND ( (assg.LOCATION_ID = lLocationId  AND
	    ASSOCIATION_TYPE = 'HR_LOCATION') OR
           (assg.ORGANIZATION_ID = lownerId  AND
	    ASSOCIATION_TYPE = 'ORGANIZATION')
         )
    Order By assg.LOCATION_ID;

Line: 40

 select assg.CALENDAR_CODE
   from wsh_calendar_assignments assg
   WHERE assg.LOCATION_ID = lLocationId
   AND CALENDAR_TYPE = lCalendarType    --'SHIPPING' or 'RECEIVING'
   AND ASSOCIATION_TYPE = 'CUSTOMER_SITE';

Line: 47

 select assg.CALENDAR_CODE
   from wsh_calendar_assignments assg
   WHERE assg.CUSTOMER_ID = lCustId
   AND CALENDAR_TYPE = lCalendarType    --'SHIPPING' or 'RECEIVING'
   AND ASSOCIATION_TYPE = 'CUSTOMER';

Line: 54

 select assg.CALENDAR_CODE
   from wsh_calendar_assignments assg
   WHERE assg.LOCATION_ID = lLocationId
   AND assg.carrier_id = lCarrierId
   AND CALENDAR_TYPE = lCalendarType    --'SHIPPING' or 'RECEIVING'
   AND ASSOCIATION_TYPE = 'CARRIER_SITE';

Line: 62

 select assg.CALENDAR_CODE
   from wsh_calendar_assignments assg
   WHERE
    assg.carrier_id = lCarrier_id
   AND CALENDAR_TYPE = lCalendarType    --'SHIPPING' or 'RECEIVING'
   AND ASSOCIATION_TYPE = 'CARRIER';

Line: 70

 select assg.CALENDAR_CODE
   from wsh_calendar_assignments assg
   WHERE assg.LOCATION_ID = lLocationId
   AND assg.VENDOR_ID = lSupplierId
   AND assg.CALENDAR_TYPE = lCalendarType
   AND assg.ASSOCIATION_TYPE = 'VENDOR_SITE';

Line: 78

 select assg.CALENDAR_CODE
   from wsh_calendar_assignments assg
   WHERE assg.VENDOR_ID = lSupplierId
   AND assg.CALENDAR_TYPE = lCalendarType
   AND assg.ASSOCIATION_TYPE = 'VENDOR';

Line: 163

 	select CALENDAR_CODE
        into lCalendar
 	from bom_calendar_dates
 	where CALENDAR_CODE = lCalendar
         and rownum = 1;

Line: 186

 select delivery_id
 into lDelId
 from wsh_new_Deliveries
 where Delivery_id = ldeliveryId
 AND  planned_flag in ( 'F'  ,'Y');

Line: 206

  select fvt.vehicle_type_id
  from wsh_trips t,
   fte_trip_moves wt,
   fte_vehicle_types fvt
  WHERE t.trip_id = wt.TRIP_ID
  and wt.MOVE_ID = lMoveId
  and t.VEHICLE_ITEM_ID = fvt.INVENTORY_ITEM_ID
  and t.VEHICLE_ORGANIZATION_ID   = fvt.ORGANIZATION_ID;

Line: 230

 select decode(det.source_line_type_code, 'OSP','Y','N')
into l_osp_flag
from wsh_Delivery_details det,
wsh_delivery_assignments assg,
wsh_new_deliveries del
where del.delivery_id= ldelivery_id
AND   del.delivery_id = assg.delivery_id
AND    assg.delivery_detail_id = det.delivery_detail_id
AND   rownum = 1;

Line: 274

  SELECT PHASE_CODE,STATUS_CODE
  FROM Fnd_Concurrent_Requests
  WHERE request_id = l_rqst_Id;