APPS.CSFW_ORDER_PARTS SQL Statements

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

Line: 43

SELECT order_number
FROM oe_order_headers_all
where header_id = v_header_id;

Line: 58

Select ORGANIZATION_ID ,SUBINVENTORY_CODE
from csp_inv_loc_assignments
where resource_id =  v_resource_id
and DEFAULT_CODE = 'IN'
and sysdate between nvl(EFFECTIVE_DATE_START, sysdate) and nvl(EFFECTIVE_DATE_END, sysdate);

Line: 193

SELECT order_number
FROM oe_order_headers_all
where header_id = v_header_id;

Line: 211

Select ORGANIZATION_ID ,SUBINVENTORY_CODE
from csp_inv_loc_assignments
where resource_id =  v_resource_id
and DEFAULT_CODE = 'IN'
and sysdate between nvl(EFFECTIVE_DATE_START, sysdate) and nvl(EFFECTIVE_DATE_END, sysdate);

Line: 220

select a.resource_id resource_id,
       b.resource_type resource_type
from jtf_rs_resource_extns a, CSP_RS_RESOURCES_V  b
where a.user_id = v_user_id
  and a.resource_id = b.resource_id;

Line: 371

SELECT REQUEST_NUMBER
FROM MTL_TXN_REQUEST_HEADERS
WHERE HEADER_ID = v_move_order_id ;

Line: 679

	select * from csp_receive_headers_v
	where RCV_SHIPMENT_HEADER_ID = v_header_id;

Line: 684

	select * from csp_receive_lines_v
	where RCV_SHIPMENT_HEADER_ID = v_header_id;

Line: 780

	receiveRec(i).update_mln                    := null;

Line: 806

	receiveRec(i).update_msn                    := null;