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.GME_RESERVATIONS_PVT dependencies on MTL_RESERVATIONS

Line 115: FROM mtl_reservations mr, wms_item_locations_kfv loc

111: ,NVL (mr.secondary_detailed_quantity, 0)
112: ,NVL (mr.secondary_reservation_quantity, 0)
113: ,mr.secondary_uom_code, mr.inventory_item_id
114: ,loc.concatenated_segments
115: FROM mtl_reservations mr, wms_item_locations_kfv loc
116: WHERE mr.organization_id = p_organization_id
117: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
118: AND mr.demand_source_header_id = p_batch_id
119: AND mr.demand_source_line_id = p_material_detail_id

Line 451: FROM mtl_reservations mr

447: ,v_batch_id NUMBER
448: ,v_material_detail_id NUMBER)
449: IS
450: SELECT mr.*
451: FROM mtl_reservations mr
452: WHERE organization_id = v_org_id
453: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
454: AND demand_source_header_id = v_batch_id
455: AND demand_source_line_id = v_material_detail_id

Line 532: FROM mtl_reservations mr

528: ,v_batch_id NUMBER
529: ,v_material_detail_id NUMBER)
530: IS
531: SELECT mr.*
532: FROM mtl_reservations mr
533: WHERE organization_id = v_org_id
534: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
535: AND demand_source_header_id = v_batch_id
536: AND demand_source_line_id = v_material_detail_id

Line 542: FROM mtl_reservations mr

538: FROM mtl_material_transactions_temp
539: WHERE reservation_id = mr.reservation_id)
540: UNION ALL
541: SELECT mr.*
542: FROM mtl_reservations mr
543: WHERE organization_id = v_org_id
544: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
545: AND demand_source_header_id = v_batch_id
546: AND demand_source_line_id = v_material_detail_id

Line 727: p_reservation_rec IN mtl_reservations%ROWTYPE

723:
724:
725:
726: FUNCTION reservation_fully_specified (
727: p_reservation_rec IN mtl_reservations%ROWTYPE
728: ,p_item_location_control IN NUMBER
729: ,p_item_restrict_locators IN NUMBER)
730: RETURN NUMBER
731: IS

Line 787: p_reservation_rec IN mtl_reservations%ROWTYPE

783: RETURN -1;
784: END reservation_fully_specified;
785:
786: PROCEDURE convert_partial_to_dlr (
787: p_reservation_rec IN mtl_reservations%ROWTYPE
788: ,p_material_dtl_rec IN gme_material_details%ROWTYPE
789: ,p_item_rec IN mtl_system_items%ROWTYPE
790: ,p_qty_check IN VARCHAR2 := fnd_api.g_false
791: ,x_reservation_rec OUT NOCOPY mtl_reservations%ROWTYPE

Line 791: ,x_reservation_rec OUT NOCOPY mtl_reservations%ROWTYPE

787: p_reservation_rec IN mtl_reservations%ROWTYPE
788: ,p_material_dtl_rec IN gme_material_details%ROWTYPE
789: ,p_item_rec IN mtl_system_items%ROWTYPE
790: ,p_qty_check IN VARCHAR2 := fnd_api.g_false
791: ,x_reservation_rec OUT NOCOPY mtl_reservations%ROWTYPE
792: ,x_return_status OUT NOCOPY VARCHAR2)
793: IS
794: l_api_name CONSTANT VARCHAR2 (30) := 'convert_partial_to_dlr';
795: l_eff_locator_control NUMBER;

Line 1055: p_reservation_rec IN mtl_reservations%ROWTYPE

1051: x_return_status := fnd_api.g_ret_sts_unexp_error;
1052: END delete_reservation;
1053:
1054: PROCEDURE get_reservation_dtl_qty (
1055: p_reservation_rec IN mtl_reservations%ROWTYPE
1056: ,p_uom_code IN VARCHAR2
1057: ,x_qty OUT NOCOPY NUMBER
1058: ,x_return_status OUT NOCOPY VARCHAR2)
1059: IS

Line 1150: FROM mtl_reservations mr

1146: -- Bug 12613813 - consider p_locator_only parameter and locator also.
1147: CURSOR cur_get_resvns
1148: IS
1149: SELECT mr.*
1150: FROM mtl_reservations mr
1151: WHERE mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
1152: AND mr.demand_source_header_id = l_mtl_dtl_rec.batch_id
1153: AND mr.demand_source_line_id = l_mtl_dtl_rec.material_detail_id
1154: AND ((p_supply_sub_only = fnd_api.g_false) OR (mr.subinventory_code = l_mtl_dtl_rec.subinventory))

Line 1535: FROM mtl_reservations mr

1531: SELECT 1
1532: FROM DUAL
1533: WHERE EXISTS (
1534: SELECT 1
1535: FROM mtl_reservations mr
1536: WHERE organization_id = v_org_id
1537: AND demand_source_type_id =
1538: gme_common_pvt.g_txn_source_type
1539: AND demand_source_header_id = v_batch_id

Line 1586: p_reservation_rec IN mtl_reservations%ROWTYPE

1582: RETURN FALSE;
1583: END pending_reservations_exist;
1584:
1585: PROCEDURE convert_dtl_reservation (
1586: p_reservation_rec IN mtl_reservations%ROWTYPE
1587: ,p_material_details_rec IN gme_material_details%ROWTYPE
1588: ,p_qty_convert IN NUMBER := NULL
1589: ,p_trans_date IN DATE DEFAULT NULL -- Bug 13532998
1590: ,x_message_count OUT NOCOPY NUMBER

Line 1602: l_reservation_rec mtl_reservations%ROWTYPE;

1598: create_transaction_error EXCEPTION;
1599: detail_reservation_error EXCEPTION;
1600: uom_conversion_failure EXCEPTION;
1601: l_item_rec mtl_system_items%ROWTYPE;
1602: l_reservation_rec mtl_reservations%ROWTYPE;
1603: l_qty_convert NUMBER;
1604: l_rsv_type NUMBER;
1605: l_return_status VARCHAR2 (1);
1606: l_actual_qty NUMBER;

Line 1840: l_rsv_rec mtl_reservations%ROWTYPE;

1836: ,x_return_status OUT NOCOPY VARCHAR2)
1837: IS
1838: l_api_name CONSTANT VARCHAR2 (30) := 'auto_detail_line';
1839: l_item_rec mtl_system_items_b%ROWTYPE;
1840: l_rsv_rec mtl_reservations%ROWTYPE;
1841: l_rsv_tbl gme_common_pvt.reservations_tab;
1842: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
1843: l_rsv_type NUMBER;
1844: l_open_qty NUMBER :=0;