APPS.GME_RESERVATIONS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 105: FROM gme_material_details d, mtl_system_items i

101:
102: CURSOR cur_reservable_ings
103: IS
104: SELECT d.*
105: FROM gme_material_details d, mtl_system_items i
106: WHERE d.batch_id = p_batch_id
107: AND d.line_type = -1
108: AND d.line_type = -1
109: AND ( NVL (p_timefence, 0) = 0

Line 509: ,p_item_rec IN mtl_system_items%ROWTYPE

505:
506: PROCEDURE convert_partial_to_dlr (
507: p_reservation_rec IN mtl_reservations%ROWTYPE
508: ,p_material_dtl_rec IN gme_material_details%ROWTYPE
509: ,p_item_rec IN mtl_system_items%ROWTYPE
510: ,p_qty_check IN VARCHAR2 := fnd_api.g_false
511: ,x_reservation_rec OUT NOCOPY mtl_reservations%ROWTYPE
512: ,x_return_status OUT NOCOPY VARCHAR2)
513: IS

Line 595: FROM gme_material_details d, mtl_system_items_b i

591:
592: CURSOR cur_batch_materials
593: IS
594: SELECT d.material_detail_id, d.batch_id, d.organization_id
595: FROM gme_material_details d, mtl_system_items_b i
596: WHERE d.organization_id = p_organization_id
597: AND d.batch_id = p_batch_id
598: AND d.line_type = gme_common_pvt.g_line_type_ing
599: AND i.organization_id = d.organization_id

Line 789: FROM mtl_system_items_kfv

785:
786: CURSOR cur_item_no (v_inventory_item_id NUMBER, v_org_id NUMBER)
787: IS
788: SELECT concatenated_segments
789: FROM mtl_system_items_kfv
790: WHERE inventory_item_id = v_inventory_item_id
791: AND organization_id = v_org_id;
792:
793: uom_conv_error EXCEPTION;

Line 1307: l_item_rec mtl_system_items%ROWTYPE;

1303: validation_error EXCEPTION;
1304: create_transaction_error EXCEPTION;
1305: detail_reservation_error EXCEPTION;
1306: uom_conversion_failure EXCEPTION;
1307: l_item_rec mtl_system_items%ROWTYPE;
1308: l_reservation_rec mtl_reservations%ROWTYPE;
1309: l_qty_convert NUMBER;
1310: l_rsv_type NUMBER;
1311: l_return_status VARCHAR2 (1);

Line 1317: FROM mtl_system_items_b

1313:
1314: CURSOR cur_fetch_item (v_org_id NUMBER, v_inventory_item_id NUMBER)
1315: IS
1316: SELECT *
1317: FROM mtl_system_items_b
1318: WHERE organization_id = v_org_id
1319: AND inventory_item_id = v_inventory_item_id;
1320: BEGIN
1321: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1341: ,'MTL_SYSTEM_ITEMS');

1337: CLOSE cur_fetch_item;
1338:
1339: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1340: ,'TABLE_NAME'
1341: ,'MTL_SYSTEM_ITEMS');
1342:
1343: IF g_debug <= gme_debug.g_log_statement THEN
1344: gme_debug.put_line
1345: ( g_pkg_name

Line 1348: || ' Retrieval failure against mtl_system_items using id of '

1344: gme_debug.put_line
1345: ( g_pkg_name
1346: || '.'
1347: || l_api_name
1348: || ' Retrieval failure against mtl_system_items using id of '
1349: || p_material_details_rec.inventory_item_id);
1350: END IF;
1351:
1352: RAISE fetch_error;

Line 1539: l_item_rec mtl_system_items_b%ROWTYPE;

1535: p_material_details_rec IN gme_material_details%ROWTYPE
1536: ,x_return_status OUT NOCOPY VARCHAR2)
1537: IS
1538: l_api_name CONSTANT VARCHAR2 (30) := 'auto_detail_line';
1539: l_item_rec mtl_system_items_b%ROWTYPE;
1540: l_rsv_rec mtl_reservations%ROWTYPE;
1541: l_rsv_tbl gme_common_pvt.reservations_tab;
1542: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
1543: l_rsv_type NUMBER;

Line 1569: FROM mtl_system_items_b

1565:
1566: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
1567: IS
1568: SELECT *
1569: FROM mtl_system_items_b
1570: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
1571:
1572: CURSOR cur_get_mo_rec (v_move_order_line_id NUMBER)
1573: IS

Line 2029: FROM gme_material_details d,mtl_system_items_b i

2025: /* Retrieve Ingredient rows */
2026: CURSOR cur_get_reservable_ings
2027: IS
2028: SELECT d.*
2029: FROM gme_material_details d,mtl_system_items_b i
2030: WHERE d.batch_id = p_batch_rec.batch_id
2031: AND d.line_type = -1
2032: AND d.material_requirement_date < SYSDATE + NVL(gme_common_pvt.g_rule_based_resv_horizon,p_timefence)
2033: AND i. inventory_item_id = d.inventory_item_id