DBA Data[Home] [Help]

APPS.MSC_GANTT_UTILS dependencies on MSC_SUPPLIER_REQUIREMENTS

Line 4028: msc_supplier_requirements msr

4024: sum(msr.overloaded_capacity) overload_qty,
4025: sum(msr.consumed_quantity) consumed_qty
4026: bulk collect into v_row_index, v_start_date, v_overload_qty, v_consumed_qty
4027: from msc_gantt_query mgq,
4028: msc_supplier_requirements msr
4029: where mgq.query_id = p_query_id
4030: and mgq.row_flag = SYS_YES
4031: and mgq.is_fetched = SYS_NO
4032: and mgq.dependency_type <> 1 -- bom_item_type, all the items except MODELs

Line 4052: msc_supplier_requirements msr,

4048: sum(msr.overloaded_capacity) overload_qty,
4049: sum(msr.consumed_quantity) consumed_qty
4050: bulk collect into v_row_index, v_start_date, v_overload_qty, v_consumed_qty
4051: from msc_gantt_query mgq,
4052: msc_supplier_requirements msr,
4053: msc_system_items msi
4054: where mgq.query_id = p_query_id
4055: and mgq.row_flag = SYS_YES
4056: and mgq.is_fetched = SYS_NO