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 2416: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe

2412: and otl.language = (select language_code
2413: from fnd_languages
2414: where installed_flag = 'B')
2415: and mso.sales_order_id = mr.demand_source_header_id
2416: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
2417: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2418: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2419: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
2420: and mr.reservation_quantity > 0

Line 2418: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,

2414: where installed_flag = 'B')
2415: and mso.sales_order_id = mr.demand_source_header_id
2416: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
2417: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2418: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2419: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
2420: and mr.reservation_quantity > 0
2421: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
2422: and rownum = 1;

Line 2419: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874

2415: and mso.sales_order_id = mr.demand_source_header_id
2416: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
2417: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2418: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2419: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
2420: and mr.reservation_quantity > 0
2421: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
2422: and rownum = 1;
2423:

Line 2421: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv

2417: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2418: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2419: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
2420: and mr.reservation_quantity > 0
2421: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
2422: and rownum = 1;
2423:
2424: IF PG_DEBUG <> 0 THEN
2425: oe_debug_pub.add ('check_inv_rsv_exists: ' || 'found that reservation exists before booking', 1);

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

2500: and otl.language = (select language_code
2501: from fnd_languages
2502: where installed_flag = 'B')
2503: and mso.sales_order_id = mr.demand_source_header_id
2504: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
2505: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2506: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2507: INV_RESERVATION_GLOBAL.g_source_type_oe)
2508: and mr.reservation_quantity > 0

Line 2506: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,

2502: where installed_flag = 'B')
2503: and mso.sales_order_id = mr.demand_source_header_id
2504: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
2505: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2506: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2507: INV_RESERVATION_GLOBAL.g_source_type_oe)
2508: and mr.reservation_quantity > 0
2509: and rownum = 1;
2510:

Line 2507: INV_RESERVATION_GLOBAL.g_source_type_oe)

2503: and mso.sales_order_id = mr.demand_source_header_id
2504: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
2505: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
2506: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
2507: INV_RESERVATION_GLOBAL.g_source_type_oe)
2508: and mr.reservation_quantity > 0
2509: and rownum = 1;
2510:
2511:

Line 2517: where demand_source_type = inv_reservation_global.g_source_type_oe

2513: -- Check to see if reservns exist in wip_flow_schedules
2514: select count(*)
2515: into lFloCount
2516: from wip_flow_schedules
2517: where demand_source_type = inv_reservation_global.g_source_type_oe
2518: and demand_source_line = to_char(pLineId)
2519: and status <> 2; -- Flow Schedule status : 1 = Open 2 = Closed/Completed
2520: else
2521: x_ResultStatus := TRUE;

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

3382: and not exists (select '1'
3383: from mtl_reservations mr
3384: where mr.demand_source_line_id = oel.line_id
3385: and mr.organization_id = oel.ship_from_org_id
3386: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3387: and mr.demand_source_type_id =
3388: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
3389: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
3390: and mr.reservation_quantity > 0);

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

3384: where mr.demand_source_line_id = oel.line_id
3385: and mr.organization_id = oel.ship_from_org_id
3386: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3387: and mr.demand_source_type_id =
3388: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
3389: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
3390: and mr.reservation_quantity > 0);
3391:
3392: if (l_quantity <= 0) then

Line 3389: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

3385: and mr.organization_id = oel.ship_from_org_id
3386: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3387: and mr.demand_source_type_id =
3388: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
3389: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
3390: and mr.reservation_quantity > 0);
3391:
3392: if (l_quantity <= 0) then
3393: IF PG_DEBUG <> 0 THEN

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

3777: (select '1'
3778: from mtl_reservations mr
3779: where mr.demand_source_line_id = oel.line_id
3780: and mr.organization_id = oel.ship_from_org_id
3781: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3782: and mr.demand_source_type_id =
3783: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
3784: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
3785: and mr.reservation_quantity > 0)

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

3779: where mr.demand_source_line_id = oel.line_id
3780: and mr.organization_id = oel.ship_from_org_id
3781: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3782: and mr.demand_source_type_id =
3783: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
3784: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
3785: and mr.reservation_quantity > 0)
3786: FOR UPDATE OF oel.line_id NOWAIT; --bugfix 2053360
3787:

Line 3784: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

3780: and mr.organization_id = oel.ship_from_org_id
3781: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3782: and mr.demand_source_type_id =
3783: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
3784: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
3785: and mr.reservation_quantity > 0)
3786: FOR UPDATE OF oel.line_id NOWAIT; --bugfix 2053360
3787:
3788:

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

4412: and msi.base_item_id is not NULL
4413: and mrs.demand_source_line_id = oel.line_id
4414: and mrs.demand_source_header_id is not NULL
4415: and mrs.organization_id = oel.ship_from_org_id
4416: --and mrs.demand_source_type_id = inv_reservation_global.g_source_type_oe
4417: and mrs.demand_source_type_id =
4418: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
4419: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
4420: and mrs.supply_source_type_id =

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

4414: and mrs.demand_source_header_id is not NULL
4415: and mrs.organization_id = oel.ship_from_org_id
4416: --and mrs.demand_source_type_id = inv_reservation_global.g_source_type_oe
4417: and mrs.demand_source_type_id =
4418: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
4419: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
4420: and mrs.supply_source_type_id =
4421: inv_reservation_global.g_source_type_inv
4422: and mrs.reservation_quantity > 0

Line 4419: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

4415: and mrs.organization_id = oel.ship_from_org_id
4416: --and mrs.demand_source_type_id = inv_reservation_global.g_source_type_oe
4417: and mrs.demand_source_type_id =
4418: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
4419: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
4420: and mrs.supply_source_type_id =
4421: inv_reservation_global.g_source_type_inv
4422: and mrs.reservation_quantity > 0
4423: group by oel.line_id;

Line 4421: inv_reservation_global.g_source_type_inv

4417: and mrs.demand_source_type_id =
4418: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
4419: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
4420: and mrs.supply_source_type_id =
4421: inv_reservation_global.g_source_type_inv
4422: and mrs.reservation_quantity > 0
4423: group by oel.line_id;
4424:
4425: return TRUE;