DBA Data[Home] [Help]

APPS.CTO_WIP_WORKFLOW_API_PK dependencies on INV_RESERVATION_GLOBAL

Line 338: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,

334: select count(*) into v_counter
335: from mtl_reservations
336: --where demand_source_type_id = 2
337: where demand_source_type_id =
338: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
339: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
340: and demand_source_line_id = order_line_id
341: and primary_reservation_quantity > 0;
342:

Line 339: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

335: from mtl_reservations
336: --where demand_source_type_id = 2
337: where demand_source_type_id =
338: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
339: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
340: and demand_source_line_id = order_line_id
341: and primary_reservation_quantity > 0;
342:
343: -- bugfix 1799874 : as per adrian suherman, we need not worry about internal SO for wip_flow_schedules.

Line 635: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,

631: select count(*) into v_counter
632: from mtl_reservations
633: -- where demand_source_type_id = 2
634: where demand_source_type_id =
635: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
636: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
637: and demand_source_line_id = order_line_id
638: and primary_reservation_quantity > 0;
639:

Line 636: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

632: from mtl_reservations
633: -- where demand_source_type_id = 2
634: where demand_source_type_id =
635: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
636: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
637: and demand_source_line_id = order_line_id
638: and primary_reservation_quantity > 0;
639:
640: -- bugfix 1799874 : as per adrian suherman, we need not worry about internal SO for wip_flow_schedules.