APPS.WSMPWROT dependencies on MTL_SYSTEM_ITEMS

Line 204: MTL_SYSTEM_ITEMS C,

200: o.department_id
201: FROM
202: WIP_OPERATIONS O,
203: BOM_INVENTORY_COMPONENTS A,
204: MTL_SYSTEM_ITEMS C,
205: BOM_EXPLOSION_TEMP BE
206: WHERE
207: BE.GROUP_ID=WSMPWROT.EXPLOSION_GROUP_ID
208: AND BE.TOP_BILL_SEQUENCE_ID=x_bill_sequence_id

Line 527: from mtl_system_items msi

523: l_stmt_num := 50.5;
524: begin
525: select 'Y'
526: into l_ato_phantom
527: from mtl_system_items msi
528: where msi.inventory_item_id = t_comp_details(i).component_item_id
529: and msi.organization_id = p_organization_id
530: and msi.replenish_to_order_flag = 'Y'
531: and msi.bom_item_type in (1,2);

Line 756: MTL_SYSTEM_ITEMS C,

752: x_start_date first_unit_start_date,
753: x_department_id department_id
754: FROM
755: BOM_INVENTORY_COMPONENTS A,
756: MTL_SYSTEM_ITEMS C,
757: BOM_EXPLOSION_TEMP BE
758: WHERE BE.GROUP_ID = WSMPWROT.EXPLOSION_GROUP_ID
759: AND A.COMPONENT_SEQUENCE_ID = BE.COMPONENT_SEQUENCE_ID
760: AND C.INVENTORY_ITEM_ID = BE.COMPONENT_ITEM_ID

Line 1018: MTL_SYSTEM_ITEMS MSI --BUG 7598223

1014: BOM_DEPARTMENT_RESOURCES BDR1,
1015: BOM_OPERATION_SEQUENCES BOS,
1016: BOM_OPERATIONAL_ROUTINGS BRTG,
1017: WIP_REQUIREMENT_OPERATIONS WRO,
1018: MTL_SYSTEM_ITEMS MSI --BUG 7598223
1019: WHERE
1020: BRTG.organization_id = p_organization_id
1021: and BRTG.assembly_item_id = wro.inventory_item_id
1022: and MSI.inventory_item_id = wro.inventory_item_id --BUG 7598223