DBA Data[Home] [Help]

APPS.GMO_SWORKBENCH_PVT dependencies on MTL_RESERVATIONS

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

593: ,x_msg_count => x_msg_count
594: ,x_msg_data => x_msg_data
595: );
596: --ns_debug_call('in create1'|| x_msg_data );
597: select reservation_id into x_res_id from mtl_reservations RES,gme_material_details GMD where GMD.organization_id =p_org_id and
598: GMD.material_detail_id =p_material_detail_id and RES.DEMAND_SOURCE_HEADER_ID (+) = GMD.BATCH_ID
599: AND RES.DEMAND_SOURCE_LINE_ID(+) = GMD.MATERIAL_DETAIL_ID;
600: EXCEPTION
601: WHEN error_get_item THEN