[Home] [Help]
5510: and the shared structure stored by the procedure
5511: GET_ATP_BOM_PUB.
5512: This procedure will get the required_qty and
5513: required_date from ATP pegging tree table
5514: MRP_ATP_DETAILS_TEMP and insert the entier row
5515: into the table BOM_CTO_ORDER_DEMAND.
5516: Input :
5517: p_ship_set - This is the IN OUT Parameter. When it is called
5518: from ATP it will have the Reduced Ship set in it.
5703: -- end 2723674
5704:
5705: -- Loop through the shared Shipset. For each record in the shared
5706: -- shipset get the required quantity and required date from the ATP
5707: -- pegging tree table MRP_ATP_DETAILS_TEMP
5708:
5709: IF PG_DEBUG <> 0 THEN
5710: oe_debug_pub.add('create_cto_model_demand: ' || 'Total no of records in the shared stuct...'|| to_char(g_final_cto_shipset.count), 2);
5711: END IF;
5990: l_required_qty,
5991: l_order_quantity_uom,
5992: l_header_id,
5993: l_record_count
5994: from MRP_ATP_DETAILS_TEMP ATP,
5995: OE_ORDER_LINES_ALL OEL
5996: where ATP.session_id = p_session_id
5997: and ATP.component_identifier = g_final_cto_shipset(i).link_to_line_id
5998: and ATP.inventory_item_id = l_par_inventory_item_id
6361: -- take the sum of the qty as the request qty and max of date as the request date.
6362:
6363:
6364: -- Get the requirement_date and requirement_qty from
6365: -- MRP_ATP_DETAILS_TEMP (Pegging Tree) table
6366:
6367:
6368: l_stmt_no := 30;
6369:
6381: l_order_quantity_uom,
6382: l_header_id,
6383: l_record_count
6384: FROM
6385: MRP_ATP_DETAILS_TEMP ATP,
6386: OE_ORDER_LINES_ALL OEL
6387: WHERE
6388: ATP.session_id = p_session_id
6389: AND ATP.component_identifier = p_line_id