[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select nvl(quantity_shipped,0)
into X_quantity_shipped
from po_line_locations
where
line_location_id = x_line_location_id;
SELECT nvl(sum(primary_quantity),0),
decode(min(item_id),null,min(unit_of_measure),min(primary_unit_of_measure))
INTO x_cancel_qty,
primary_uom
FROM rcv_transactions_interface
WHERE transaction_status_code = 'PENDING'
AND transaction_type = 'CANCEL'
AND po_line_location_id = x_line_location_id;
select nvl(quantity_shipped,0)
into X_quantity_shipped
from po_line_locations
where
line_location_id = x_line_location_id;
SELECT unit_of_measure
INTO X_primary_uom
FROM mtl_units_of_measure mum
WHERE uom_class = x_unit_of_measure_class
AND mum.base_uom_flag = 'Y';
SELECT msi.primary_unit_of_measure
INTO X_primary_uom
FROM mtl_system_items msi
WHERE inventory_item_id = x_item_id
AND organization_id = x_org_id;
** with the form I need to do this select temporarily until I can fix the
** view.
*/
IF (x_receipt_source_code = 'VENDOR') THEN
X_progress := '060';
select displayed_field, lookup_code into x_destination_type_dsp, x_destination_type_code
from po_lookup_codes where
lookup_CODE = 'RECEIVING' and
lookup_type = 'RCV DESTINATION TYPE'; */
SELECT project_id, task_id
INTO X_project_id,X_task_id
FROM oe_order_lines_all
WHERE line_id = x_oe_order_line_id;
select pa.project_number,pt.task_number
into x_project_number,x_task_number
from pjm_projects_all_v pa,
pa_tasks_expend_v pt
where pa.project_id = X_project_id
and pt.task_id = X_task_id
and pa.project_id=pt.project_id;
select project_number
into x_project_number
from pjm_projects_all_v
where project_id = X_project_id;
/* SELECT currency_conversion_rate,currency_conversion_date
INTO x_rate,x_rate_date
FROM rcv_enter_receipts_rma_v
WHERE oe_order_header_id = x_oe_order_header_id
AND oe_order_line_id = x_oe_order_line_id; */
SELECT conversion_rate, conversion_rate_date
INTO x_rate, x_rate_date
FROM oe_order_headers_all
WHERE header_id = x_oe_order_header_id; */
a different select to improve performance.The deliver to
person's full name is got from the above view only when
the deliver_to_person_id is not null.
Bug 1205660 - Select the req distribution id which will be used
later to get the project_id and task_id from req distributions.
GMudgal 2-28-2000
*/
SELECT rsl.destination_type_code,
polc.displayed_field,
rsl.deliver_to_person_id,
rsl.deliver_to_location_id,
hlo.location_code,
rsl.to_subinventory,
rsl.req_distribution_id,
MKC.kanban_card_number, --
PPA.project_number, --
PTE.task_number, --
PRD.code_combination_id --
INTO x_destination_type_code,
x_destination_type_dsp,
x_deliver_to_person_id,
x_deliver_to_location_id ,
x_deliver_to_location,
x_deliver_to_sub,
x_req_distribution_id,
x_kanban_card_number, --
x_project_number, --
x_task_number, --
l_code_combination_id --
FROM rcv_shipment_lines rsl,
hr_locations hlo,
po_lookup_codes polc,
po_requisition_lines PRL, --
po_req_distributions PRD, --
mtl_kanban_cards MKC, --
pjm_projects_all_v PPA, --
pa_tasks_expend_v PTE --
WHERE polc.lookup_type = 'RCV DESTINATION TYPE'
AND polc.lookup_code = NVL( rsl.destination_type_code, 'INVENTORY')
AND rsl.shipment_line_id = x_shipment_line_id
AND hlo.location_id(+) = rsl.deliver_to_location_id
AND RSL.requisition_line_id = PRL.requisition_line_id (+) --
AND PRL.kanban_card_id = MKC.kanban_card_id (+) --
AND PRL.requisition_line_id = PRD.requisition_line_id (+) --
AND PRD.project_id = PPA.project_id (+) --
AND PRD.task_id = PTE.task_id (+); --
SELECT NVL(receiving_routing_id,0)
INTO x_routing_id
FROM mtl_system_items
WHERE inventory_item_id = x_item_id
AND organization_id = x_org_id;
SELECT NVL(ROUTING_HEADER_ID,0)
INTO x_routing_id
FROM MTL_INTERORG_PARAMETERS
WHERE FROM_ORGANIZATION_ID = x_from_org_id
AND TO_ORGANIZATION_ID = x_org_id;
SELECT NVL(RECEIVING_ROUTING_ID,0)
INTO x_routing_id
FROM RCV_PARAMETERS
WHERE ORGANIZATION_ID = x_org_id;
SELECT routing_header_id
INTO x_ms_routing_id
FROM rcv_shipment_lines
WHERE shipment_line_id = x_shipment_line_id;
SELECT 'Check to see if subinventory is valid'
INTO x_subinv
FROM mtl_secondary_inventories
WHERE (disable_date IS NULL OR disable_date > SYSDATE)
AND organization_id = x_org_id
AND secondary_inventory_name = x_deliver_to_sub;
** not already been selected or if the subinventory has been
** modified
*/
IF (x_destination_type_code = 'INVENTORY' AND
x_locator_control IS NULL AND
x_deliver_to_sub IS NOT NULL) THEN
po_subinventories_s.get_locator_control (
x_org_id,
x_deliver_to_sub,
x_item_id,
x_locator_control);
** Anytime a subinventory is selected then the locator field
** should be prepopulated with the default locator_id from
** mtl_item_loc_defaults for the item, org and subinventory
** and where the default_type = 2
*/
po_subinventories_s.get_default_locator (
x_org_id,
x_item_id,
x_deliver_to_sub,
x_deliver_to_locator_id);
select locator_id
into x_deliver_to_locator_id
from rcv_shipment_lines
where shipment_line_id = x_shipment_line_id;
SELECT project_id, task_id
INTO X_project_id, X_task_id
FROM po_distributions
WHERE po_distribution_id = X_po_distributions_id;
for the following select statement.
*/
begin
X_progress := '134';
SELECT project_id, task_id
INTO X_project_id, X_task_id
FROM po_req_distributions
WHERE distribution_id = x_req_distribution_id;
SELECT project_id, task_id
INTO X_project_id,X_task_id
FROM oe_order_lines_all
WHERE line_id = x_oe_order_line_id;