DBA Data[Home] [Help]

APPS.MRP_HORIZONTAL_PLAN_SC dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 2172: mtl_onhand_quantities_detail moq,

2168: 0 old_quantity
2169: FROM
2170: mtl_item_locations mil,
2171: mtl_lot_numbers lots,
2172: mtl_onhand_quantities_detail moq,
2173: mrp_sub_inventories sub,
2174: mrp_system_items items,
2175: mrp_plan_organizations_v orgs,
2176: mrp_form_query list

Line 2234: FROM MTL_Onhand_Quantities_detail moq,

2230: to_date(1, 'J') new_date,
2231: to_date(1, 'J') old_date,
2232: NVL(SUM(moq.primary_transaction_quantity),0) new_quantity,
2233: 0 old_quantity
2234: FROM MTL_Onhand_Quantities_detail moq,
2235: mtl_parameters param,
2236: mtl_material_statuses mms,
2237: mrp_system_items masis,
2238: MTL_LOT_NUMBERS mln,