APPS.INV_LABEL dependencies on MTL_ITEM_REVISIONS_B

Line 2288: l_revision mtl_item_revisions_b.REVISION%TYPE;

2284: l_range_schedule_numbers serial_tab_type;
2285: l_lot_control_code NUMBER := 1;
2286: --Bug8329454
2287: l_rev_control_code NUMBER := 1;
2288: l_revision mtl_item_revisions_b.REVISION%TYPE;
2289: BEGIN
2290:
2291:
2292: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 3859: FROM MTL_CROSS_REFERENCES MCR, MTL_ITEM_REVISIONS_B MIR

3855: IF (p_revision IS NOT NULL) THEN
3856:
3857: SELECT MCR.CROSS_REFERENCE, MCR.DESCRIPTION, MCR.REVISION_ID, MCR.UOM_CODE
3858: INTO x_gtin, x_gtin_desc, l_revision_id, l_uom_code
3859: FROM MTL_CROSS_REFERENCES MCR, MTL_ITEM_REVISIONS_B MIR
3860: WHERE CROSS_REFERENCE_TYPE = G_PROFILE_GTIN
3861: AND MIR.INVENTORY_ITEM_ID = MCR.INVENTORY_ITEM_ID
3862: AND MIR.INVENTORY_ITEM_ID = p_inventory_item_id
3863: AND MIR.REVISION_ID = nvl(MCR.REVISION_ID,MIR.REVISION_ID)