DBA Data[Home] [Help]

APPS.PO_LINES_SV11 dependencies on MTL_SYSTEM_ITEMS

Line 318: mtl_system_items ai

314: BEGIN
315: SELECT oi.item_id , oi.item_um2, oi.dualum_ind
316: INTO l_opm_item_id, l_item_um2, l_dualum_ind
317: FROM ic_item_mst oi,
318: mtl_system_items ai
319: WHERE ai.organization_id = x_ship_org_id
320: AND ai.inventory_item_id = x_item_id
321: AND ai.segment1 = oi.item_no;
322:

Line 439: mtl_system_items ai

435: --Get opm attributes to derive secondary quantity.
436: SELECT oi.item_id , oi.item_um2, oi.dualum_ind
437: INTO l_opm_item_id, l_item_um2, l_dualum_ind
438: FROM ic_item_mst oi,
439: mtl_system_items ai
440: WHERE ai.organization_id = X_ship_org_id
441: AND ai.inventory_item_id = X_item_id
442: AND ai.segment1 = oi.item_no;
443: