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_WORKFLOW dependencies on INV_RESERVATION_GLOBAL

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

2445: and otl.language = (select language_code
2446: from fnd_languages
2447: where installed_flag = 'B')
2448: and mso.sales_order_id = mr.demand_source_header_id
2449: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
2450: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2451: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2452: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
2453: and mr.reservation_quantity > 0

Line 2451: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,

2447: where installed_flag = 'B')
2448: and mso.sales_order_id = mr.demand_source_header_id
2449: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
2450: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2451: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2452: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
2453: and mr.reservation_quantity > 0
2454: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
2455: and rownum = 1;

Line 2452: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874

2448: and mso.sales_order_id = mr.demand_source_header_id
2449: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
2450: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2451: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2452: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
2453: and mr.reservation_quantity > 0
2454: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
2455: and rownum = 1;
2456:

Line 2454: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv

2450: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2451: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2452: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
2453: and mr.reservation_quantity > 0
2454: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
2455: and rownum = 1;
2456:
2457: IF PG_DEBUG <> 0 THEN
2458: oe_debug_pub.add ('check_inv_rsv_exists: ' || 'found that reservation exists before booking', 1);

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

2533: and otl.language = (select language_code
2534: from fnd_languages
2535: where installed_flag = 'B')
2536: and mso.sales_order_id = mr.demand_source_header_id
2537: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
2538: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2539: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2540: INV_RESERVATION_GLOBAL.g_source_type_oe)
2541: and mr.reservation_quantity > 0

Line 2539: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,

2535: where installed_flag = 'B')
2536: and mso.sales_order_id = mr.demand_source_header_id
2537: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
2538: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2539: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2540: INV_RESERVATION_GLOBAL.g_source_type_oe)
2541: and mr.reservation_quantity > 0
2542: and rownum = 1;
2543:

Line 2540: INV_RESERVATION_GLOBAL.g_source_type_oe)

2536: and mso.sales_order_id = mr.demand_source_header_id
2537: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
2538: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2539: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2540: INV_RESERVATION_GLOBAL.g_source_type_oe)
2541: and mr.reservation_quantity > 0
2542: and rownum = 1;
2543:
2544:

Line 2550: where demand_source_type = inv_reservation_global.g_source_type_oe

2546: -- Check to see if reservns exist in wip_flow_schedules
2547: select count(*)
2548: into lFloCount
2549: from wip_flow_schedules
2550: where demand_source_type = inv_reservation_global.g_source_type_oe
2551: and demand_source_line = to_char(pLineId)
2552: and status <> 2; -- Flow Schedule status : 1 = Open 2 = Closed/Completed
2553: else
2554: x_ResultStatus := TRUE;

Line 3419: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe

3415: and not exists (select '1'
3416: from mtl_reservations mr
3417: where mr.demand_source_line_id = oel.line_id
3418: and mr.organization_id = oel.ship_from_org_id
3419: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3420: and mr.demand_source_type_id =
3421: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
3422: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
3423: and mr.reservation_quantity > 0);

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

3417: where mr.demand_source_line_id = oel.line_id
3418: and mr.organization_id = oel.ship_from_org_id
3419: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3420: and mr.demand_source_type_id =
3421: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
3422: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
3423: and mr.reservation_quantity > 0);
3424:
3425: if (l_quantity <= 0) then

Line 3422: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

3418: and mr.organization_id = oel.ship_from_org_id
3419: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3420: and mr.demand_source_type_id =
3421: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
3422: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
3423: and mr.reservation_quantity > 0);
3424:
3425: if (l_quantity <= 0) then
3426: IF PG_DEBUG <> 0 THEN

Line 3814: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe

3810: (select '1'
3811: from mtl_reservations mr
3812: where mr.demand_source_line_id = oel.line_id
3813: and mr.organization_id = oel.ship_from_org_id
3814: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3815: and mr.demand_source_type_id =
3816: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
3817: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
3818: and mr.reservation_quantity > 0)

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

3812: where mr.demand_source_line_id = oel.line_id
3813: and mr.organization_id = oel.ship_from_org_id
3814: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3815: and mr.demand_source_type_id =
3816: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
3817: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
3818: and mr.reservation_quantity > 0)
3819: FOR UPDATE OF oel.line_id NOWAIT; --bugfix 2053360
3820:

Line 3817: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

3813: and mr.organization_id = oel.ship_from_org_id
3814: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3815: and mr.demand_source_type_id =
3816: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
3817: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
3818: and mr.reservation_quantity > 0)
3819: FOR UPDATE OF oel.line_id NOWAIT; --bugfix 2053360
3820:
3821:

Line 4515: --and mrs.demand_source_type_id = inv_reservation_global.g_source_type_oe

4511: and msi.base_item_id is not NULL
4512: and mrs.demand_source_line_id = oel.line_id
4513: and mrs.demand_source_header_id is not NULL
4514: and mrs.organization_id = oel.ship_from_org_id
4515: --and mrs.demand_source_type_id = inv_reservation_global.g_source_type_oe
4516: and mrs.demand_source_type_id =
4517: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
4518: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
4519: and mrs.supply_source_type_id =

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

4513: and mrs.demand_source_header_id is not NULL
4514: and mrs.organization_id = oel.ship_from_org_id
4515: --and mrs.demand_source_type_id = inv_reservation_global.g_source_type_oe
4516: and mrs.demand_source_type_id =
4517: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
4518: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
4519: and mrs.supply_source_type_id =
4520: inv_reservation_global.g_source_type_inv
4521: and mrs.reservation_quantity > 0

Line 4518: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

4514: and mrs.organization_id = oel.ship_from_org_id
4515: --and mrs.demand_source_type_id = inv_reservation_global.g_source_type_oe
4516: and mrs.demand_source_type_id =
4517: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
4518: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
4519: and mrs.supply_source_type_id =
4520: inv_reservation_global.g_source_type_inv
4521: and mrs.reservation_quantity > 0
4522: group by oel.line_id;

Line 4520: inv_reservation_global.g_source_type_inv

4516: and mrs.demand_source_type_id =
4517: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
4518: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
4519: and mrs.supply_source_type_id =
4520: inv_reservation_global.g_source_type_inv
4521: and mrs.reservation_quantity > 0
4522: group by oel.line_id;
4523:
4524: return TRUE;