DBA Data[Home] [Help]

APPS.PO_LINES_SV11 dependencies on MTL_SYSTEM_ITEMS

Line 333: mtl_system_items ai

329: BEGIN
330: SELECT oi.item_id , oi.item_um2, oi.dualum_ind
331: INTO l_opm_item_id, l_item_um2, l_dualum_ind
332: FROM ic_item_mst oi,
333: mtl_system_items ai
334: WHERE ai.organization_id = x_ship_org_id
335: AND ai.inventory_item_id = x_item_id
336: AND ai.segment1 = oi.item_no;
337:

Line 456: mtl_system_items ai

452: --Get opm attributes to derive secondary quantity.
453: SELECT oi.item_id , oi.item_um2, oi.dualum_ind
454: INTO l_opm_item_id, l_item_um2, l_dualum_ind
455: FROM ic_item_mst oi,
456: mtl_system_items ai
457: WHERE ai.organization_id = X_ship_org_id
458: AND ai.inventory_item_id = X_item_id
459: AND ai.segment1 = oi.item_no;
460: