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 3896: inv_reservation_global.g_source_type_internal_ord,

3892: select nvl(sum(mr.primary_reservation_quantity),0)
3893: into l_reservation_qty
3894: from mtl_reservations mr
3895: where mr.demand_source_type_id = decode (l_source_document_type_id, 10,
3896: inv_reservation_global.g_source_type_internal_ord,
3897: inv_reservation_global.g_source_type_oe )
3898: and mr.primary_reservation_quantity > 0
3899: and mr.demand_source_line_id = p_order_line_id;
3900:

Line 3897: inv_reservation_global.g_source_type_oe )

3893: into l_reservation_qty
3894: from mtl_reservations mr
3895: where mr.demand_source_type_id = decode (l_source_document_type_id, 10,
3896: inv_reservation_global.g_source_type_internal_ord,
3897: inv_reservation_global.g_source_type_oe )
3898: and mr.primary_reservation_quantity > 0
3899: and mr.demand_source_line_id = p_order_line_id;
3900:
3901:

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

4577: and otl.language = (select language_code
4578: from fnd_languages
4579: where installed_flag = 'B')
4580: and mso.sales_order_id = mr.demand_source_header_id
4581: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
4582: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
4583: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
4584: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
4585: and mr.reservation_quantity > 0;

Line 4583: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,

4579: where installed_flag = 'B')
4580: and mso.sales_order_id = mr.demand_source_header_id
4581: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
4582: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
4583: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
4584: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
4585: and mr.reservation_quantity > 0;
4586:
4587:

Line 4584: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874

4580: and mso.sales_order_id = mr.demand_source_header_id
4581: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
4582: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
4583: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
4584: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
4585: and mr.reservation_quantity > 0;
4586:
4587:
4588:

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

5698: and otl.language = (select language_code
5699: from fnd_languages
5700: where installed_flag ='B')
5701: and mso.sales_order_id = mr.demand_source_header_id
5702: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
5703: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10, INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
5704: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
5705: and mr.reservation_quantity > 0
5706: and rownum = 1;

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

5699: from fnd_languages
5700: where installed_flag ='B')
5701: and mso.sales_order_id = mr.demand_source_header_id
5702: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
5703: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10, INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
5704: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
5705: and mr.reservation_quantity > 0
5706: and rownum = 1;
5707: IF PG_DEBUG <> 0 THEN

Line 5704: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874

5700: where installed_flag ='B')
5701: and mso.sales_order_id = mr.demand_source_header_id
5702: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
5703: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10, INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
5704: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
5705: and mr.reservation_quantity > 0
5706: and rownum = 1;
5707: IF PG_DEBUG <> 0 THEN
5708: oe_debug_pub.add('Reservation_Exists: ' || 'Work order/Inv reservation Exists..',5);

Line 7224: inv_reservation_global.g_source_type_internal_ord,

7220: lot_number,
7221: max(organization_id) organization_id
7222: from mtl_reservations
7223: where demand_source_type_id = decode (l_source_document_type_id, 10,
7224: inv_reservation_global.g_source_type_internal_ord,
7225: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
7226: and demand_source_line_id = p_order_line_id
7227: and supply_source_type_id IN
7228: ( inv_reservation_global.g_source_type_inv,

Line 7225: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

7221: max(organization_id) organization_id
7222: from mtl_reservations
7223: where demand_source_type_id = decode (l_source_document_type_id, 10,
7224: inv_reservation_global.g_source_type_internal_ord,
7225: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
7226: and demand_source_line_id = p_order_line_id
7227: and supply_source_type_id IN
7228: ( inv_reservation_global.g_source_type_inv,
7229: inv_reservation_global.g_source_type_wip,

Line 7228: ( inv_reservation_global.g_source_type_inv,

7224: inv_reservation_global.g_source_type_internal_ord,
7225: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
7226: and demand_source_line_id = p_order_line_id
7227: and supply_source_type_id IN
7228: ( inv_reservation_global.g_source_type_inv,
7229: inv_reservation_global.g_source_type_wip,
7230: inv_reservation_global.g_source_type_po,
7231: inv_reservation_global.g_source_type_req,
7232: inv_reservation_global.g_source_type_internal_req,

Line 7229: inv_reservation_global.g_source_type_wip,

7225: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
7226: and demand_source_line_id = p_order_line_id
7227: and supply_source_type_id IN
7228: ( inv_reservation_global.g_source_type_inv,
7229: inv_reservation_global.g_source_type_wip,
7230: inv_reservation_global.g_source_type_po,
7231: inv_reservation_global.g_source_type_req,
7232: inv_reservation_global.g_source_type_internal_req,
7233: inv_reservation_global.g_source_type_asn,

Line 7230: inv_reservation_global.g_source_type_po,

7226: and demand_source_line_id = p_order_line_id
7227: and supply_source_type_id IN
7228: ( inv_reservation_global.g_source_type_inv,
7229: inv_reservation_global.g_source_type_wip,
7230: inv_reservation_global.g_source_type_po,
7231: inv_reservation_global.g_source_type_req,
7232: inv_reservation_global.g_source_type_internal_req,
7233: inv_reservation_global.g_source_type_asn,
7234: inv_reservation_global.g_source_type_rcv

Line 7231: inv_reservation_global.g_source_type_req,

7227: and supply_source_type_id IN
7228: ( inv_reservation_global.g_source_type_inv,
7229: inv_reservation_global.g_source_type_wip,
7230: inv_reservation_global.g_source_type_po,
7231: inv_reservation_global.g_source_type_req,
7232: inv_reservation_global.g_source_type_internal_req,
7233: inv_reservation_global.g_source_type_asn,
7234: inv_reservation_global.g_source_type_rcv
7235: )

Line 7232: inv_reservation_global.g_source_type_internal_req,

7228: ( inv_reservation_global.g_source_type_inv,
7229: inv_reservation_global.g_source_type_wip,
7230: inv_reservation_global.g_source_type_po,
7231: inv_reservation_global.g_source_type_req,
7232: inv_reservation_global.g_source_type_internal_req,
7233: inv_reservation_global.g_source_type_asn,
7234: inv_reservation_global.g_source_type_rcv
7235: )
7236: group by supply_source_type_id,

Line 7233: inv_reservation_global.g_source_type_asn,

7229: inv_reservation_global.g_source_type_wip,
7230: inv_reservation_global.g_source_type_po,
7231: inv_reservation_global.g_source_type_req,
7232: inv_reservation_global.g_source_type_internal_req,
7233: inv_reservation_global.g_source_type_asn,
7234: inv_reservation_global.g_source_type_rcv
7235: )
7236: group by supply_source_type_id,
7237: lot_number; --Bugfix 13554996

Line 7234: inv_reservation_global.g_source_type_rcv

7230: inv_reservation_global.g_source_type_po,
7231: inv_reservation_global.g_source_type_req,
7232: inv_reservation_global.g_source_type_internal_req,
7233: inv_reservation_global.g_source_type_asn,
7234: inv_reservation_global.g_source_type_rcv
7235: )
7236: group by supply_source_type_id,
7237: lot_number; --Bugfix 13554996
7238:

Line 7439: p_demand_source_type => inv_reservation_global.g_source_type_oe,

7435: END IF;
7436:
7437: v_open_flow_qty :=
7438: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY( p_demand_source_line => to_char(p_order_line_id),
7439: p_demand_source_type => inv_reservation_global.g_source_type_oe,
7440: p_demand_source_delivery => NULL,
7441: p_use_open_quantity => 'Y');
7442: IF PG_DEBUG <> 0 THEN
7443: oe_debug_pub.add('get_resv_qty:'||'flow open quantity =>' || v_open_flow_qty, 5);