DBA Data[Home] [Help]

APPS.CTO_CHANGE_ORDER_PK dependencies on INV_RESERVATION_GLOBAL

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

1292: and otl.language = (select language_code
1293: from fnd_languages
1294: where installed_flag ='B')
1295: and mso.sales_order_id = mr.demand_source_header_id
1296: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
1297: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10, INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
1298: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
1299: and mr.reservation_quantity > 0
1300: and rownum = 1;

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

1293: from fnd_languages
1294: where installed_flag ='B')
1295: and mso.sales_order_id = mr.demand_source_header_id
1296: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
1297: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10, INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
1298: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
1299: and mr.reservation_quantity > 0
1300: and rownum = 1;
1301: IF PG_DEBUG <> 0 THEN

Line 1298: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874

1294: where installed_flag ='B')
1295: and mso.sales_order_id = mr.demand_source_header_id
1296: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
1297: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10, INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
1298: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
1299: and mr.reservation_quantity > 0
1300: and rownum = 1;
1301: IF PG_DEBUG <> 0 THEN
1302: oe_debug_pub.add('Reservation_Exists: ' || 'Work order/Inv reservation Exists..',5);