DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on MTL_PARAMETERS

Line 568: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,

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
572: AND op1.wip_entity_id = wor.wip_entity_id

Line 752: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,

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
756: AND op1.wip_entity_id = wor.wip_entity_id

Line 1455: mtl_parameters mp,

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
1459: AND mp.organization_id = msi.organization_id