APPS.EGO_TRANSACTION_ATTRS_PVT dependencies on MTL_ITEM_REVISIONS_VL

Line 2494: l_creation_date DATE;-- MTL_ITEM_REVISIONS_VL.CREATION_DATE

2490: IS
2491:
2492: l_item_catalog_group_id VARCHAR2(10);
2493: l_efectivity_date DATE ; /*Item revision effective date.*/
2494: l_creation_date DATE;-- MTL_ITEM_REVISIONS_VL.CREATION_DATE
2495: l_icc_start_date DATE ;/*ICC start effective date*/
2496: l_start_active_date DATE ;/*ICC start effective date*/
2497: l_icc_create_date DATE ;/*ICC create date*/
2498: l_version_seq_id VARCHAR2(5);

Line 2690: FROM MTL_ITEM_REVISIONS_VL WHERE INVENTORY_ITEM_ID = p_inventory_item_id

2686: IF(l_ITEM_CATALOG_GROUP_ID IS NULL ) THEN
2687: RAISE l_exception ;
2688: ELSE
2689: SELECT EFFECTIVITY_DATE ,CREATION_DATE INTO l_efectivity_date,l_creation_date
2690: FROM MTL_ITEM_REVISIONS_VL WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2691: AND ORGANIZATION_ID = p_organization_id AND REVISION_ID = p_revision_id;
2692:
2693: --Finding out which ICC version is effective at a time of item creation.
2694: