[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT decode(msi.mrp_planning_code, 3,'Y',4,'Y',7,'Y',8,'Y',9,'Y',
decode(msi.inventory_planning_code,1,'Y',2,'Y', 'N')),
msi.outside_operation_flag ,
msi.outside_operation_uom_type,
msi.invoice_close_tolerance,
receive_close_tolerance,
msi.receipt_required_flag,
nvl(msi.stock_enabled_flag,'N'),
nvl(msi.internal_order_enabled_flag,'N'),
nvl(msi.purchasing_enabled_flag,'N'),
msi.inventory_asset_flag,
decode(msi.tracking_quantity_ind,'PS',msi.secondary_default_ind,NULL),
msi.grade_control_flag,
decode(msi.tracking_quantity_ind,'PS',mum.unit_of_measure,NULL)
INTO X_planned_item_flag ,
X_outside_operation_flag ,
X_outside_op_uom_type ,
X_invoice_close_tolerance ,
X_receive_close_tolerance ,
X_receipt_required_flag ,
X_stock_enabled_flag ,
X_internal_orderable ,
X_purchasing_enabled ,
X_inventory_asset_flag ,
/* INVCONV BEGIN PBAMB */
X_secondary_default_ind ,
X_grade_control_flag ,
X_secondary_unit_of_measure
/* INVCONV END PBAMB */
FROM mtl_system_items msi , mtl_units_of_measure mum
WHERE inventory_item_id = X_item_id
AND organization_id = X_inventory_organization_id
AND mum.uom_code(+) = msi.secondary_uom_code;
SELECT decode(msi.outside_operation_flag,'Y','O',
decode(msi.stock_enabled_flag,'Y','E','D'))
INTO X_item_status
FROM mtl_system_items msi
WHERE msi.organization_id = X_ship_org_id
AND msi.inventory_item_id = X_item_id;
SELECT max(mir.revision) -- Bug 448708 (a no of revisions could have same effective date
INTO X_item_revision -- thus returning more than 1 row and causing errors
FROM mtl_item_revisions mir -- Use max to return the maximum revision num)
WHERE mir.organization_id = X_organization_id
AND mir.inventory_item_id = X_item_id
AND mir.effectivity_date in
(SELECT MAX(mir2.effectivity_date)
FROM mtl_item_revisions mir2
WHERE mir2.organization_id = X_organization_id
AND mir2.inventory_item_id = X_item_id
/* Bug 1407438 - Filtering revisions which are not effective on current
date and also those which are not implemented */
AND mir2.effectivity_date <= SYSDATE
AND mir2.implementation_date is not NULL);
SELECT msi.revision_qty_control_code
INTO X_item_rev_control
FROM mtl_system_items_kfv msi
WHERE X_item_id = msi.inventory_item_id
AND X_to_organization_id = msi.organization_id;
Select starting_revision
into default_item_revision
from mtl_parameters
where organization_id = X_to_organization_id;
SELECT cic.item_cost
INTO x_inv_cost
FROM cst_item_costs_for_gl_view cic
WHERE cic.inventory_item_id = x_item_id
AND cic.organization_id = x_organization_id;