APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on MTL_ITEM_REVISIONS

Line 39: EXECUTE IMMEDIATE 'SELECT IR.REVISION FROM MTL_ITEM_REVISIONS_B IR

35: ,p_organization_id NUMBER)
36: RETURN VARCHAR2 IS
37: l_rev VARCHAR2(5);
38: BEGIN
39: EXECUTE IMMEDIATE 'SELECT IR.REVISION FROM MTL_ITEM_REVISIONS_B IR
40: WHERE IR.INVENTORY_ITEM_ID = :1
41: AND IR.ORGANIZATION_ID = :2
42: AND IR.REVISION_ID IN
43: (SELECT MAX(IR2.REVISION_ID)

Line 45: FROM MTL_ITEM_REVISIONS_B IR2

41: AND IR.ORGANIZATION_ID = :2
42: AND IR.REVISION_ID IN
43: (SELECT MAX(IR2.REVISION_ID)
44: KEEP (DENSE_RANK LAST ORDER BY IR2.EFFECTIVITY_DATE )
45: FROM MTL_ITEM_REVISIONS_B IR2
46: WHERE IR2.ORGANIZATION_ID = IR.ORGANIZATION_ID
47: AND IR2.INVENTORY_ITEM_ID = IR.INVENTORY_ITEM_ID
48: AND IR2.EFFECTIVITY_DATE <= SYSDATE
49: AND IR2.IMPLEMENTATION_DATE IS NOT NULL

Line 68: FROM MTL_ITEM_REVISIONS

64: RETURN VARCHAR2 IS
65: l_temp VARCHAR2(5);
66: BEGIN
67: EXECUTE IMMEDIATE 'SELECT REVISION
68: FROM MTL_ITEM_REVISIONS
69: WHERE INVENTORY_ITEM_ID = :1
70: AND ORGANIZATION_ID = :2
71: AND REVISION = :3' INTO l_temp USING p_inventory_item_id, p_organization_id, p_revision;
72: RETURN 'Y'; -- Return true

Line 726: l_revision MTL_ITEM_REVISIONS.REVISION%TYPE;

722: l_lifecycle_id NUMBER;
723: l_phase_id NUMBER;
724: l_primay_ag_disp_name FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
725: l_primary_ag_int_name FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
726: l_revision MTL_ITEM_REVISIONS.REVISION%TYPE;
727: l_rev_attr_count NUMBER;
728: l_attr_group_display_name VARCHAR2(200);
729:
730: -- Variables for Security issues

Line 1773: l_sql_query := ' FROM EGO_MTL_SY_ITEMS_EXT_VL I, EGO_ATTR_GROUPS_DL_V AG, MTL_ITEM_REVISIONS_B REV'||

1769: ' AND I.INVENTORY_ITEM_ID = :1'||
1770: ' AND I.ORGANIZATION_ID = :2';
1771: ELSE --IF rec_attr.REVISION IS NULL THEN
1772: -- If there are attributes with Revisions ... Get Attributes in for given Attribute Group.
1773: l_sql_query := ' FROM EGO_MTL_SY_ITEMS_EXT_VL I, EGO_ATTR_GROUPS_DL_V AG, MTL_ITEM_REVISIONS_B REV'||
1774: ' WHERE AG.APPLICATION_ID = 431 '||
1775: ' AND NVL(AG.ATTR_GROUP_TYPE, ''EGO_ITEMMGMT_GROUP'') = ''EGO_ITEMMGMT_GROUP'' '||
1776: ' AND AG.ATTR_GROUP_ID = I.ATTR_GROUP_ID'||
1777: ' AND I.INVENTORY_ITEM_ID = REV.INVENTORY_ITEM_ID ' ||