APPS.CTO_CONFIG_ITEM_PK dependencies on INV_RESERVATION_GLOBAL

Line 767: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,

763: from fnd_languages
764: where installed_flag = 'B')
765: and mso.sales_order_id = mr.demand_source_header_id
766: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
767: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
768: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
769: and mr.reservation_quantity > 0
770: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip
771: and rownum = 1;

Line 768: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874

764: where installed_flag = 'B')
765: and mso.sales_order_id = mr.demand_source_header_id
766: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
767: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
768: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
769: and mr.reservation_quantity > 0
770: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip
771: and rownum = 1;
772:

Line 770: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip

766: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
767: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
768: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
769: and mr.reservation_quantity > 0
770: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip
771: and rownum = 1;
772:
773: IF PG_DEBUG <> 0 THEN
774: oe_debug_pub.add ('work_orders_exist: ' || 'Work orders exist! Call wip_holds api', 2);

Line 838: l_rsv INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;

834: lSalesOrderId number;
835: lHeaderId number;
836: lSourceCode varchar2(30);
837:
838: l_rsv INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
839: l_rsv_id number;
840: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
841: l_status varchar2(1);
842: lShipConfirmed varchar2(10);

Line 840: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;

836: lSourceCode varchar2(30);
837:
838: l_rsv INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
839: l_rsv_id number;
840: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
841: l_status varchar2(1);
842: lShipConfirmed varchar2(10);
843:
844: --Begin Bugfix 1997355

Line 879: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,

875: from fnd_languages
876: where installed_flag = 'B')
877: and mso.sales_order_id = mr.demand_source_header_id
878: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
879: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
880: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
881: and mr.reservation_quantity > 0;
882:
883: --Begin Bugfix 1997355

Line 880: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874

876: where installed_flag = 'B')
877: and mso.sales_order_id = mr.demand_source_header_id
878: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
879: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
880: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
881: and mr.reservation_quantity > 0;
882:
883: --Begin Bugfix 1997355
884: