APPS.CTO_CONFIG_ITEM_PK dependencies on INV_RESERVATION_GLOBAL

Line 842: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,

838: from fnd_languages
839: where installed_flag = 'B')
840: and mso.sales_order_id = mr.demand_source_header_id
841: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
842: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
843: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
844: and mr.reservation_quantity > 0
845: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip
846: and rownum = 1;

Line 843: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874

839: where installed_flag = 'B')
840: and mso.sales_order_id = mr.demand_source_header_id
841: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
842: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
843: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
844: and mr.reservation_quantity > 0
845: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip
846: and rownum = 1;
847:

Line 845: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip

841: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
842: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
843: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
844: and mr.reservation_quantity > 0
845: and supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip
846: and rownum = 1;
847:
848: IF PG_DEBUG <> 0 THEN
849: oe_debug_pub.add ('work_orders_exist: ' || 'Work orders exist! Call wip_holds api', 2);

Line 913: l_rsv INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;

909: lSalesOrderId number;
910: lHeaderId number;
911: lSourceCode varchar2(30);
912:
913: l_rsv INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
914: l_rsv_id number;
915: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
916: l_status varchar2(1);
917: lShipConfirmed varchar2(10);

Line 915: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;

911: lSourceCode varchar2(30);
912:
913: l_rsv INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
914: l_rsv_id number;
915: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
916: l_status varchar2(1);
917: lShipConfirmed varchar2(10);
918:
919: --Begin Bugfix 1997355

Line 954: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,

950: from fnd_languages
951: where installed_flag = 'B')
952: and mso.sales_order_id = mr.demand_source_header_id
953: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
954: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
955: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
956: and mr.reservation_quantity > 0;
957:
958: --Begin Bugfix 1997355

Line 955: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874

951: where installed_flag = 'B')
952: and mso.sales_order_id = mr.demand_source_header_id
953: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
954: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
955: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
956: and mr.reservation_quantity > 0;
957:
958: --Begin Bugfix 1997355
959: