eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_UTILITY_PK dependencies on INV_RESERVATION_GLOBAL

Line 3874: inv_reservation_global.g_source_type_internal_ord,

3870: select nvl(sum(mr.primary_reservation_quantity),0)
3871: into l_reservation_qty
3872: from mtl_reservations mr
3873: where mr.demand_source_type_id = decode (l_source_document_type_id, 10,
3874: inv_reservation_global.g_source_type_internal_ord,
3875: inv_reservation_global.g_source_type_oe )
3876: and mr.primary_reservation_quantity > 0
3877: and mr.demand_source_line_id = p_order_line_id;
3878:

Line 3875: inv_reservation_global.g_source_type_oe )

3871: into l_reservation_qty
3872: from mtl_reservations mr
3873: where mr.demand_source_type_id = decode (l_source_document_type_id, 10,
3874: inv_reservation_global.g_source_type_internal_ord,
3875: inv_reservation_global.g_source_type_oe )
3876: and mr.primary_reservation_quantity > 0
3877: and mr.demand_source_line_id = p_order_line_id;
3878:
3879:

Line 4557: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe

4553: and otl.language = (select language_code
4554: from fnd_languages
4555: where installed_flag = 'B')
4556: and mso.sales_order_id = mr.demand_source_header_id
4557: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
4558: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
4559: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
4560: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
4561: and mr.reservation_quantity > 0;

Line 4559: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,

4555: where installed_flag = 'B')
4556: and mso.sales_order_id = mr.demand_source_header_id
4557: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
4558: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
4559: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
4560: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
4561: and mr.reservation_quantity > 0;
4562:
4563:

Line 4560: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874

4556: and mso.sales_order_id = mr.demand_source_header_id
4557: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
4558: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
4559: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
4560: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
4561: and mr.reservation_quantity > 0;
4562:
4563:
4564:

Line 5678: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe

5674: and otl.language = (select language_code
5675: from fnd_languages
5676: where installed_flag ='B')
5677: and mso.sales_order_id = mr.demand_source_header_id
5678: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
5679: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10, INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
5680: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
5681: and mr.reservation_quantity > 0
5682: and rownum = 1;

Line 5679: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10, INV_RESERVATION_GLOBAL.g_source_type_internal_ord,

5675: from fnd_languages
5676: where installed_flag ='B')
5677: and mso.sales_order_id = mr.demand_source_header_id
5678: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
5679: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10, INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
5680: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
5681: and mr.reservation_quantity > 0
5682: and rownum = 1;
5683: IF PG_DEBUG <> 0 THEN

Line 5680: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874

5676: where installed_flag ='B')
5677: and mso.sales_order_id = mr.demand_source_header_id
5678: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
5679: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10, INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
5680: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
5681: and mr.reservation_quantity > 0
5682: and rownum = 1;
5683: IF PG_DEBUG <> 0 THEN
5684: oe_debug_pub.add('Reservation_Exists: ' || 'Work order/Inv reservation Exists..',5);

Line 7198: inv_reservation_global.g_source_type_internal_ord,

7194: sum(nvl(reservation_quantity,0)) secondary_reservation_quantity, --OPM
7195: supply_source_type_id
7196: from mtl_reservations
7197: where demand_source_type_id = decode (l_source_document_type_id, 10,
7198: inv_reservation_global.g_source_type_internal_ord,
7199: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
7200: and demand_source_line_id = p_order_line_id
7201: and supply_source_type_id IN
7202: ( inv_reservation_global.g_source_type_inv,

Line 7199: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

7195: supply_source_type_id
7196: from mtl_reservations
7197: where demand_source_type_id = decode (l_source_document_type_id, 10,
7198: inv_reservation_global.g_source_type_internal_ord,
7199: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
7200: and demand_source_line_id = p_order_line_id
7201: and supply_source_type_id IN
7202: ( inv_reservation_global.g_source_type_inv,
7203: inv_reservation_global.g_source_type_wip,

Line 7202: ( inv_reservation_global.g_source_type_inv,

7198: inv_reservation_global.g_source_type_internal_ord,
7199: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
7200: and demand_source_line_id = p_order_line_id
7201: and supply_source_type_id IN
7202: ( inv_reservation_global.g_source_type_inv,
7203: inv_reservation_global.g_source_type_wip,
7204: inv_reservation_global.g_source_type_po,
7205: inv_reservation_global.g_source_type_req,
7206: inv_reservation_global.g_source_type_internal_req,

Line 7203: inv_reservation_global.g_source_type_wip,

7199: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
7200: and demand_source_line_id = p_order_line_id
7201: and supply_source_type_id IN
7202: ( inv_reservation_global.g_source_type_inv,
7203: inv_reservation_global.g_source_type_wip,
7204: inv_reservation_global.g_source_type_po,
7205: inv_reservation_global.g_source_type_req,
7206: inv_reservation_global.g_source_type_internal_req,
7207: inv_reservation_global.g_source_type_asn,

Line 7204: inv_reservation_global.g_source_type_po,

7200: and demand_source_line_id = p_order_line_id
7201: and supply_source_type_id IN
7202: ( inv_reservation_global.g_source_type_inv,
7203: inv_reservation_global.g_source_type_wip,
7204: inv_reservation_global.g_source_type_po,
7205: inv_reservation_global.g_source_type_req,
7206: inv_reservation_global.g_source_type_internal_req,
7207: inv_reservation_global.g_source_type_asn,
7208: inv_reservation_global.g_source_type_rcv

Line 7205: inv_reservation_global.g_source_type_req,

7201: and supply_source_type_id IN
7202: ( inv_reservation_global.g_source_type_inv,
7203: inv_reservation_global.g_source_type_wip,
7204: inv_reservation_global.g_source_type_po,
7205: inv_reservation_global.g_source_type_req,
7206: inv_reservation_global.g_source_type_internal_req,
7207: inv_reservation_global.g_source_type_asn,
7208: inv_reservation_global.g_source_type_rcv
7209: )

Line 7206: inv_reservation_global.g_source_type_internal_req,

7202: ( inv_reservation_global.g_source_type_inv,
7203: inv_reservation_global.g_source_type_wip,
7204: inv_reservation_global.g_source_type_po,
7205: inv_reservation_global.g_source_type_req,
7206: inv_reservation_global.g_source_type_internal_req,
7207: inv_reservation_global.g_source_type_asn,
7208: inv_reservation_global.g_source_type_rcv
7209: )
7210: group by supply_source_type_id;

Line 7207: inv_reservation_global.g_source_type_asn,

7203: inv_reservation_global.g_source_type_wip,
7204: inv_reservation_global.g_source_type_po,
7205: inv_reservation_global.g_source_type_req,
7206: inv_reservation_global.g_source_type_internal_req,
7207: inv_reservation_global.g_source_type_asn,
7208: inv_reservation_global.g_source_type_rcv
7209: )
7210: group by supply_source_type_id;
7211:

Line 7208: inv_reservation_global.g_source_type_rcv

7204: inv_reservation_global.g_source_type_po,
7205: inv_reservation_global.g_source_type_req,
7206: inv_reservation_global.g_source_type_internal_req,
7207: inv_reservation_global.g_source_type_asn,
7208: inv_reservation_global.g_source_type_rcv
7209: )
7210: group by supply_source_type_id;
7211:
7212: --opm and ireq

Line 7319: p_demand_source_type => inv_reservation_global.g_source_type_oe,

7315:
7316: lStmtNum := 40;
7317: v_open_flow_qty :=
7318: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY( p_demand_source_line => to_char(p_order_line_id),
7319: p_demand_source_type => inv_reservation_global.g_source_type_oe,
7320: p_demand_source_delivery => NULL,
7321: p_use_open_quantity => 'Y');
7322: IF PG_DEBUG <> 0 THEN
7323: oe_debug_pub.add('get_resv_qty:'||'flow open quantity =>' || v_open_flow_qty, 5);