DBA Data[Home] [Help]

APPS.MRP_SCHEDULE_ITEMS_PKG dependencies on MFG_LOOKUPS

Line 372: MFG_LOOKUPS l1,

368: FROM MTL_SYSTEM_ITEMS msi,
369: BOM_CALENDAR_DATES cal2,
370: MTL_PARAMETERS param,
371: BOM_CALENDAR_DATES cal1,
372: MFG_LOOKUPS l1,
373: MFG_LOOKUPS l2
374: WHERE msi.organization_id = X_organization_id
375: AND msi.inventory_item_id = X_inventory_item_id
376: AND l1.lookup_type = 'BOM_ITEM_TYPE'

Line 373: MFG_LOOKUPS l2

369: BOM_CALENDAR_DATES cal2,
370: MTL_PARAMETERS param,
371: BOM_CALENDAR_DATES cal1,
372: MFG_LOOKUPS l1,
373: MFG_LOOKUPS l2
374: WHERE msi.organization_id = X_organization_id
375: AND msi.inventory_item_id = X_inventory_item_id
376: AND l1.lookup_type = 'BOM_ITEM_TYPE'
377: AND l1.lookup_code = msi.bom_item_type