1773: select count(*)
1774: into v_counter
1775: from mtl_reservations
1776: where demand_source_type_id = decode (l_source_document_type_id, 10,
1777: inv_reservation_global.g_source_type_internal_ord,
1778: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
1779: and demand_source_line_id = p_order_line_id
1780: and primary_reservation_quantity > 0;
1781:
1774: into v_counter
1775: from mtl_reservations
1776: where demand_source_type_id = decode (l_source_document_type_id, 10,
1777: inv_reservation_global.g_source_type_internal_ord,
1778: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
1779: and demand_source_line_id = p_order_line_id
1780: and primary_reservation_quantity > 0;
1781:
1782: If PG_DEBUG <> 0 Then
1805:
1806: if v_counter2 = 0 then
1807: v_counter2 :=
1808: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY( p_demand_source_line => to_char(p_order_line_id),
1809: p_demand_source_type => inv_reservation_global.g_source_type_oe,
1810: p_demand_source_delivery => NULL,
1811: p_use_open_quantity => 'Y');
1812: end if;
1813: -- end bugfix 3174334
3631: x_token2 := 'ELIGIBLE';
3632: End if;
3633: Else
3634: l_stmt_num := 40;
3635: l_inv_src_id := inv_reservation_global.g_source_type_inv;
3636: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3637: l_po_src_id := inv_reservation_global.g_source_type_po;
3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock
3632: End if;
3633: Else
3634: l_stmt_num := 40;
3635: l_inv_src_id := inv_reservation_global.g_source_type_inv;
3636: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3637: l_po_src_id := inv_reservation_global.g_source_type_po;
3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3633: Else
3634: l_stmt_num := 40;
3635: l_inv_src_id := inv_reservation_global.g_source_type_inv;
3636: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3637: l_po_src_id := inv_reservation_global.g_source_type_po;
3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3634: l_stmt_num := 40;
3635: l_inv_src_id := inv_reservation_global.g_source_type_inv;
3636: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3637: l_po_src_id := inv_reservation_global.g_source_type_po;
3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3636: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3637: l_po_src_id := inv_reservation_global.g_source_type_po;
3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3643: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3644: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3637: l_po_src_id := inv_reservation_global.g_source_type_po;
3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3643: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3644: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3645: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;
3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3643: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3644: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3645: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;
3646: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;
3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3643: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3644: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3645: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;
3646: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;
3647: --end cross_dock