APPS.WIP_OSP dependencies on MTL_SYSTEM_ITEMS

Line 91: mtl_system_items msi

87:
88: CURSOR Cuom IS
89: SELECT msi.PRIMARY_UOM_CODE
90: FROM wip_entities we,
91: mtl_system_items msi
92: WHERE we.wip_entity_id = P_Wip_Entity_Id
93: AND we.organization_id = P_Organization_Id
94: AND msi.inventory_item_id = we.primary_item_id
95: AND msi.organization_id = we.organization_id;

Line 615: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,

611: HR_ORGANIZATION_INFORMATION hoi,
612: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
613: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
614: FND_USER fu, BOM_DEPARTMENTS bd,
615: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
616: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
617: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
618: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
619: WHERE op1.organization_id = wor.organization_id

Line 808: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,

804: HR_ORGANIZATION_INFORMATION hoi,
805: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
806: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
807: FND_USER fu, BOM_DEPARTMENTS bd,
808: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
809: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
810: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
811: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
812: WHERE op1.organization_id = wor.organization_id

Line 1128: from mtl_system_items msi

1124: NULL, -- to_unit
1125: p_uom_code, -- from_name
1126: p_primary_uom_code))
1127: into l_move_qty
1128: from mtl_system_items msi
1129: where msi.inventory_item_id = p_item_id
1130: and msi.organization_id = p_organization_id;
1131:
1132: --apparently this value indicates an error condition

Line 1547: mtl_system_items msi,

1543: NULL, wo1.last_unit_completion_date,
1544: wo2.first_unit_start_date)))))) new_need_by_date
1545: FROM bom_calendar_dates bcd1,
1546: bom_calendar_dates bcd2,
1547: mtl_system_items msi,
1548: mtl_parameters mp,
1549: wip_operations wo1,
1550: wip_operations wo2
1551: WHERE mp.organization_id = p_org_id

Line 1952: FROM mtl_system_items msi,

1948: ph.type_lookup_code po_req_type,
1949: ph.authorization_status approval_status,
1950: msi.primary_uom_code uom_code,
1951: pd.org_id ou_id -- operating unit
1952: FROM mtl_system_items msi,
1953: po_distributions_all pd,
1954: po_headers_all ph,
1955: po_lines_all pl,
1956: po_line_locations_all pll,

Line 2028: FROM mtl_system_items msi,

2024: ph.type_lookup_code po_req_type,
2025: pr.authorization_status approval_status,
2026: msi.primary_uom_code uom_code,
2027: pd.org_id ou_id -- operating unit
2028: FROM mtl_system_items msi,
2029: po_distributions_all pd,
2030: po_headers_all ph,
2031: po_lines_all pl,
2032: po_line_locations_all pll,

Line 2098: FROM mtl_system_items msi,

2094: 'REQUISITION' po_req_type,
2095: prh.authorization_status approval_status,
2096: msi.primary_uom_code uom_code,
2097: prl.org_id ou_id -- operating unit
2098: FROM mtl_system_items msi,
2099: po_requisition_headers_all prh,
2100: po_requisition_lines_all prl,
2101: wip_operation_resources wor,
2102: wip_operations wo,