DBA Data[Home] [Help]

APPS.PO_SHARED_PROC_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 1169: mtl_item_revisions_b mir,

1165: --SQL Why: To validate the item and revision
1166: SELECT 'Y'
1167: INTO l_valid_flag
1168: FROM mtl_system_items_b msi,
1169: mtl_item_revisions_b mir,
1170: mtl_parameters mp
1171: WHERE msi.inventory_item_id = p_item_id
1172: AND msi.organization_id = p_inv_org_id
1173: AND mir.organization_id = msi.organization_id