DBA Data[Home] [Help]

APPS.CTO_CHANGE_ORDER_PK dependencies on INV_RESERVATION_GLOBAL

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

1273: and otl.language = (select language_code
1274: from fnd_languages
1275: where installed_flag ='B')
1276: and mso.sales_order_id = mr.demand_source_header_id
1277: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
1278: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10, INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
1279: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
1280: and mr.reservation_quantity > 0
1281: and rownum = 1;

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

1274: from fnd_languages
1275: where installed_flag ='B')
1276: and mso.sales_order_id = mr.demand_source_header_id
1277: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
1278: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10, INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
1279: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
1280: and mr.reservation_quantity > 0
1281: and rownum = 1;
1282: IF PG_DEBUG <> 0 THEN

Line 1279: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874

1275: where installed_flag ='B')
1276: and mso.sales_order_id = mr.demand_source_header_id
1277: --and mr.demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
1278: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10, INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
1279: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
1280: and mr.reservation_quantity > 0
1281: and rownum = 1;
1282: IF PG_DEBUG <> 0 THEN
1283: oe_debug_pub.add('Reservation_Exists: ' || 'Work order/Inv reservation Exists..',5);