DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on MTL_SYSTEM_ITEMS

Line 87: mtl_system_items msi

83:
84: CURSOR Cuom IS
85: SELECT msi.PRIMARY_UOM_CODE
86: FROM wip_entities we,
87: mtl_system_items msi
88: WHERE we.wip_entity_id = P_Wip_Entity_Id
89: AND we.organization_id = P_Organization_Id
90: AND msi.inventory_item_id = we.primary_item_id
91: AND msi.organization_id = we.organization_id;

Line 567: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,

563: HR_ORGANIZATION_INFORMATION hoi,
564: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
565: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
566: FND_USER fu, BOM_DEPARTMENTS bd,
567: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
568: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
569: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
570: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
571: WHERE op1.organization_id = wor.organization_id

Line 751: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,

747: HR_ORGANIZATION_INFORMATION hoi,
748: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
749: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
750: FND_USER fu, BOM_DEPARTMENTS bd,
751: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
752: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
753: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
754: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
755: WHERE op1.organization_id = wor.organization_id

Line 1042: from mtl_system_items msi

1038: decode (nvl(p_usage_rate_or_amount, 0) ,
1039: 0, 0,
1040: p_quantity/p_usage_rate_or_amount))
1041: into l_move_qty
1042: from mtl_system_items msi
1043: where msi.inventory_item_id = p_item_id
1044: and msi.organization_id = p_organization_id;
1045:
1046: --apparently this value indicates an error condition

Line 1454: mtl_system_items msi,

1450: NULL, wo1.last_unit_completion_date,
1451: wo2.first_unit_start_date))))) new_need_by_date
1452: FROM bom_calendar_dates bcd1,
1453: bom_calendar_dates bcd2,
1454: mtl_system_items msi,
1455: mtl_parameters mp,
1456: wip_operations wo1,
1457: wip_operations wo2
1458: WHERE mp.organization_id = p_org_id

Line 1844: FROM mtl_system_items msi,

1840: ph.type_lookup_code po_req_type,
1841: ph.authorization_status approval_status,
1842: msi.primary_uom_code uom_code,
1843: pd.org_id ou_id -- operating unit
1844: FROM mtl_system_items msi,
1845: po_distributions_all pd,
1846: po_headers_all ph,
1847: po_lines_all pl,
1848: po_line_locations_all pll,

Line 1907: FROM mtl_system_items msi,

1903: ph.type_lookup_code po_req_type,
1904: pr.authorization_status approval_status,
1905: msi.primary_uom_code uom_code,
1906: pd.org_id ou_id -- operating unit
1907: FROM mtl_system_items msi,
1908: po_distributions_all pd,
1909: po_headers_all ph,
1910: po_lines_all pl,
1911: po_line_locations_all pll,

Line 1977: FROM mtl_system_items msi,

1973: 'REQUISITION' po_req_type,
1974: prh.authorization_status approval_status,
1975: msi.primary_uom_code uom_code,
1976: prl.org_id ou_id -- operating unit
1977: FROM mtl_system_items msi,
1978: po_requisition_headers_all prh,
1979: po_requisition_lines_all prl,
1980: wip_operation_resources wor,
1981: wip_operations wo,