DBA Data[Home] [Help]

APPS.GMO_SWORKBENCH_PVT dependencies on MTL_RESERVATIONS

Line 483: select reservation_id into x_res_id from mtl_reservations RES,gme_material_details GMD where GMD.organization_id =p_org_id and

479: ,x_msg_count => x_msg_count
480: ,x_msg_data => x_msg_data
481: );
482: --ns_debug_call('in create1'|| x_msg_data );
483: select reservation_id into x_res_id from mtl_reservations RES,gme_material_details GMD where GMD.organization_id =p_org_id and
484: GMD.material_detail_id =p_material_detail_id and RES.DEMAND_SOURCE_HEADER_ID (+) = GMD.BATCH_ID
485: AND RES.DEMAND_SOURCE_LINE_ID(+) = GMD.MATERIAL_DETAIL_ID;
486: EXCEPTION
487: WHEN error_get_item THEN