APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on MTL_ITEM_REVISIONS

Line 1115: FROM MTL_ITEM_REVISIONS MIR

1111: WHERE UAI.DATA_SET_ID = p_data_set_id
1112: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
1113: AND UAI.REVISION_ID IS NOT NULL
1114: AND NOT EXISTS (SELECT 'X'
1115: FROM MTL_ITEM_REVISIONS MIR
1116: WHERE MIR.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1117: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1118: AND MIR.REVISION_ID = UAI.REVISION_ID);
1119: ELSE

Line 1126: FROM MTL_ITEM_REVISIONS MIR

1122: WHERE UAI.DATA_SET_ID = p_data_set_id
1123: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
1124: AND UAI.REVISION_ID IS NOT NULL
1125: AND NOT EXISTS (SELECT 'X'
1126: FROM MTL_ITEM_REVISIONS MIR
1127: WHERE MIR.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1128: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1129: AND MIR.REVISION_ID = UAI.REVISION_ID
1130: UNION ALL

Line 1132: FROM MTL_ITEM_REVISIONS_INTERFACE miri

1128: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1129: AND MIR.REVISION_ID = UAI.REVISION_ID
1130: UNION ALL
1131: SELECT 'X'
1132: FROM MTL_ITEM_REVISIONS_INTERFACE miri
1133: WHERE miri.SET_PROCESS_ID = UAI.DATA_SET_ID
1134: AND miri.PROCESS_FLAG = 1
1135: AND miri.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1136: AND miri.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 1149: FROM MTL_ITEM_REVISIONS MIR

1145: ----------------------------------------------------------------
1146: IF p_validate_only = FND_API.G_FALSE THEN
1147: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1148: SET UAI.REVISION_ID = (SELECT MIR.REVISION_ID
1149: FROM MTL_ITEM_REVISIONS MIR
1150: WHERE MIR.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1151: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1152: AND MIR.REVISION = UAI.REVISION)
1153: WHERE UAI.DATA_SET_ID = p_data_set_id

Line 1158: FROM MTL_ITEM_REVISIONS MIR2

1154: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
1155: AND UAI.REVISION IS NOT NULL
1156: AND UAI.REVISION_ID IS NULL
1157: AND EXISTS (SELECT MIR2.REVISION_ID
1158: FROM MTL_ITEM_REVISIONS MIR2
1159: WHERE MIR2.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1160: AND MIR2.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1161: AND MIR2.REVISION = UAI.REVISION);
1162: ELSE

Line 1165: FROM MTL_ITEM_REVISIONS MIR

1161: AND MIR2.REVISION = UAI.REVISION);
1162: ELSE
1163: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1164: SET UAI.REVISION_ID = NVL( (SELECT MIR.REVISION_ID
1165: FROM MTL_ITEM_REVISIONS MIR
1166: WHERE MIR.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1167: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1168: AND MIR.REVISION = UAI.REVISION
1169: ),

Line 1171: FROM MTL_ITEM_REVISIONS_INTERFACE miri

1167: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1168: AND MIR.REVISION = UAI.REVISION
1169: ),
1170: (SELECT miri.REVISION_ID
1171: FROM MTL_ITEM_REVISIONS_INTERFACE miri
1172: WHERE miri.SET_PROCESS_ID = UAI.DATA_SET_ID
1173: AND miri.PROCESS_FLAG = 1
1174: AND miri.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1175: AND miri.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 1185: FROM MTL_ITEM_REVISIONS MIR2

1181: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
1182: AND UAI.REVISION IS NOT NULL
1183: AND UAI.REVISION_ID IS NULL
1184: AND EXISTS (SELECT 'X'
1185: FROM MTL_ITEM_REVISIONS MIR2
1186: WHERE MIR2.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1187: AND MIR2.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1188: AND MIR2.REVISION = UAI.REVISION
1189: UNION ALL

Line 1191: FROM MTL_ITEM_REVISIONS_INTERFACE miri

1187: AND MIR2.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1188: AND MIR2.REVISION = UAI.REVISION
1189: UNION ALL
1190: SELECT 'X'
1191: FROM MTL_ITEM_REVISIONS_INTERFACE miri
1192: WHERE miri.SET_PROCESS_ID = UAI.DATA_SET_ID
1193: AND miri.PROCESS_FLAG = 1
1194: AND miri.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1195: AND miri.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 2101: FROM MTL_ITEM_REVISIONS MIR

2097: IF p_validate_only = FND_API.G_FALSE THEN
2098: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
2099: SET (UAI.PROG_INT_NUM3)
2100: = NVL((SELECT MIR.CURRENT_PHASE_ID
2101: FROM MTL_ITEM_REVISIONS MIR
2102: WHERE MIR.REVISION_ID = UAI.REVISION_ID
2103: ), UAI.PROG_INT_NUM3),
2104: PROG_INT_CHAR2 =
2105: NVL((SELECT 'Y'

Line 2106: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

2102: WHERE MIR.REVISION_ID = UAI.REVISION_ID
2103: ), UAI.PROG_INT_NUM3),
2104: PROG_INT_CHAR2 =
2105: NVL((SELECT 'Y'
2106: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
2107: WHERE MIRI.REVISION_ID = UAI.REVISION_ID
2108: AND MIRI.request_id = UAI.REQUEST_ID
2109: AND MIRI.TRANSACTION_TYPE = 'CREATE'
2110: AND MIRI.PROCESS_FLAG = 7

Line 2121: FROM MTL_ITEM_REVISIONS mir

2117: ELSE
2118: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
2119: SET UAI.PROG_INT_NUM3
2120: = NVL((CASE WHEN EXISTS (SELECT 1
2121: FROM MTL_ITEM_REVISIONS mir
2122: WHERE mir.REVISION_ID = UAI.REVISION_ID
2123: )
2124: THEN (SELECT mir1.CURRENT_PHASE_ID
2125: FROM MTL_ITEM_REVISIONS mir1

Line 2125: FROM MTL_ITEM_REVISIONS mir1

2121: FROM MTL_ITEM_REVISIONS mir
2122: WHERE mir.REVISION_ID = UAI.REVISION_ID
2123: )
2124: THEN (SELECT mir1.CURRENT_PHASE_ID
2125: FROM MTL_ITEM_REVISIONS mir1
2126: WHERE mir1.REVISION_ID = UAI.REVISION_ID
2127: )
2128: ELSE (SELECT miri.CURRENT_PHASE_ID
2129: FROM MTL_ITEM_REVISIONS_INTERFACE miri

Line 2129: FROM MTL_ITEM_REVISIONS_INTERFACE miri

2125: FROM MTL_ITEM_REVISIONS mir1
2126: WHERE mir1.REVISION_ID = UAI.REVISION_ID
2127: )
2128: ELSE (SELECT miri.CURRENT_PHASE_ID
2129: FROM MTL_ITEM_REVISIONS_INTERFACE miri
2130: WHERE miri.REVISION_ID = UAI.REVISION_ID
2131: AND miri.SET_PROCESS_ID = UAI.DATA_SET_ID
2132: AND miri.PROCESS_FLAG = 1
2133: AND ROWNUM = 1

Line 2139: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI1

2135: END
2136: ), UAI.PROG_INT_NUM3),
2137: PROG_INT_CHAR2 =
2138: NVL((SELECT 'Y'
2139: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI1
2140: WHERE MIRI1.REVISION_ID = UAI.REVISION_ID
2141: AND MIRI1.SET_PROCESS_ID = UAI.DATA_SET_ID
2142: AND MIRI1.TRANSACTION_TYPE = 'CREATE'
2143: AND MIRI1.PROCESS_FLAG = 1