APPS.GME_PENDING_PRODUCT_LOTS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 182: FROM mtl_system_items msi

178:
179: /* nsinghi bug#4486074 Start */
180: CURSOR Cur_item_dtl IS
181: SELECT msi.shelf_life_code, msi.shelf_life_days
182: FROM mtl_system_items msi
183: WHERE msi.inventory_item_id = p_inventory_item_id
184: AND msi.organization_id = p_organization_id;
185: /* nsinghi bug#4486074 End */
186:

Line 570: l_item_rec mtl_system_items_b%ROWTYPE;

566: ,x_return_status OUT NOCOPY VARCHAR2) IS
567:
568: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_create';
569:
570: l_item_rec mtl_system_items_b%ROWTYPE;
571:
572: error_not_lot_control EXCEPTION;
573: error_no_lot_create EXCEPTION;
574: error_get_item_rec EXCEPTION;

Line 688: l_item_rec mtl_system_items_b%ROWTYPE;

684: l_in_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
685: l_lot_number mtl_lot_numbers.lot_number%TYPE;
686: l_dtl_qty NUMBER;
687: l_sec_qty NUMBER;
688: l_item_rec mtl_system_items_b%ROWTYPE;
689:
690: l_sequence NUMBER;
691:
692: BEGIN

Line 894: l_item_rec mtl_system_items_b%ROWTYPE;

890: l_sec_qty NUMBER;
891:
892: l_sequence NUMBER;
893:
894: l_item_rec mtl_system_items_b%ROWTYPE;
895:
896: error_validate EXCEPTION;
897: error_fetch_row EXCEPTION;
898: error_get_item EXCEPTION;

Line 1194: FROM mtl_system_items_b

1190: l_msg_count NUMBER;
1191:
1192: CURSOR cur_get_uom (v_item_id NUMBER, v_org_id NUMBER) IS
1193: SELECT primary_uom_code, secondary_uom_code
1194: FROM mtl_system_items_b
1195: WHERE inventory_item_id = v_item_id
1196: AND organization_id = v_org_id;
1197:
1198: error_um_conv EXCEPTION;

Line 1442: FUNCTION validate_revision (p_item_rec IN mtl_system_items_b%ROWTYPE

1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1439: RETURN FALSE;
1440: END validate_sequence;
1441:
1442: FUNCTION validate_revision (p_item_rec IN mtl_system_items_b%ROWTYPE
1443: ,p_revision IN VARCHAR2
1444: ,x_return_status OUT NOCOPY VARCHAR2)
1445: RETURN BOOLEAN IS
1446: