APPS.GME_PENDING_PRODUCT_LOTS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 174: FROM mtl_system_items msi

170:
171: /* nsinghi bug#4486074 Start */
172: CURSOR Cur_item_dtl IS
173: SELECT msi.shelf_life_code, msi.shelf_life_days
174: FROM mtl_system_items msi
175: WHERE msi.inventory_item_id = p_inventory_item_id
176: AND msi.organization_id = p_organization_id;
177: /* nsinghi bug#4486074 End */
178:

Line 557: l_item_rec mtl_system_items_b%ROWTYPE;

553: ,x_return_status OUT NOCOPY VARCHAR2) IS
554:
555: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_create';
556:
557: l_item_rec mtl_system_items_b%ROWTYPE;
558:
559: error_not_lot_control EXCEPTION;
560: error_no_lot_create EXCEPTION;
561: error_get_item_rec EXCEPTION;

Line 675: l_item_rec mtl_system_items_b%ROWTYPE;

671: l_in_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
672: l_lot_number mtl_lot_numbers.lot_number%TYPE;
673: l_dtl_qty NUMBER;
674: l_sec_qty NUMBER;
675: l_item_rec mtl_system_items_b%ROWTYPE;
676:
677: l_sequence NUMBER;
678:
679: BEGIN

Line 881: l_item_rec mtl_system_items_b%ROWTYPE;

877: l_sec_qty NUMBER;
878:
879: l_sequence NUMBER;
880:
881: l_item_rec mtl_system_items_b%ROWTYPE;
882:
883: error_validate EXCEPTION;
884: error_fetch_row EXCEPTION;
885: error_get_item EXCEPTION;

Line 1181: FROM mtl_system_items_b

1177: l_msg_count NUMBER;
1178:
1179: CURSOR cur_get_uom (v_item_id NUMBER, v_org_id NUMBER) IS
1180: SELECT primary_uom_code, secondary_uom_code
1181: FROM mtl_system_items_b
1182: WHERE inventory_item_id = v_item_id
1183: AND organization_id = v_org_id;
1184:
1185: error_um_conv EXCEPTION;

Line 1429: FUNCTION validate_revision (p_item_rec IN mtl_system_items_b%ROWTYPE

1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1426: RETURN FALSE;
1427: END validate_sequence;
1428:
1429: FUNCTION validate_revision (p_item_rec IN mtl_system_items_b%ROWTYPE
1430: ,p_revision IN VARCHAR2
1431: ,x_return_status OUT NOCOPY VARCHAR2)
1432: RETURN BOOLEAN IS
1433: