DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on MRP_FORECAST_DESIGNATORS

Line 730: mrp_forecast_designators desig,

726: WHERE DECODE(ool.source_document_type_id,
727: 10, 8, DECODE(ool.line_category_code, 'ORDER', 2, 12)) in (2,8)
728: GROUP BY inventory_item_id,ship_from_org_id,schedule_ship_date,
729: sold_to_org_id,demand_class_code, ship_to_org_id,invoice_to_org_id) md,
730: mrp_forecast_designators desig,
731: ( SELECT
732: forecast_designator,
733: organization_id,
734: sum(original_forecast_quantity) original_forecast_quantity,

Line 1003: mrp_forecast_designators desig,

999: mtl_parameters mp,
1000: mtl_system_items_kfv sys3,
1001: mtl_system_items_kfv sys2,
1002: mtl_system_items_kfv sys,
1003: mrp_forecast_designators desig,
1004: mrp_forecast_dates dates
1005: WHERE PART.party_id (+) = CA.party_id
1006: AND org.organization_id = desig.organization_id
1007: AND ar.lookup_type(+) = 'CUSTOMER CLASS'