APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on MTL_ITEM_REVISIONS

Line 926: FROM MTL_ITEM_REVISIONS MIR

922: WHERE UAI.DATA_SET_ID = p_data_set_id
923: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
924: AND UAI.REVISION_ID IS NOT NULL
925: AND NOT EXISTS (SELECT 'X'
926: FROM MTL_ITEM_REVISIONS MIR
927: WHERE MIR.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
928: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
929: AND MIR.REVISION_ID = UAI.REVISION_ID);
930: ELSE

Line 937: FROM MTL_ITEM_REVISIONS MIR

933: WHERE UAI.DATA_SET_ID = p_data_set_id
934: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
935: AND UAI.REVISION_ID IS NOT NULL
936: AND NOT EXISTS (SELECT 'X'
937: FROM MTL_ITEM_REVISIONS MIR
938: WHERE MIR.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
939: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
940: AND MIR.REVISION_ID = UAI.REVISION_ID
941: UNION ALL

Line 943: FROM MTL_ITEM_REVISIONS_INTERFACE miri

939: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
940: AND MIR.REVISION_ID = UAI.REVISION_ID
941: UNION ALL
942: SELECT 'X'
943: FROM MTL_ITEM_REVISIONS_INTERFACE miri
944: WHERE miri.SET_PROCESS_ID = UAI.DATA_SET_ID
945: AND miri.PROCESS_FLAG = 1
946: AND miri.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
947: AND miri.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 960: FROM MTL_ITEM_REVISIONS MIR

956: ----------------------------------------------------------------
957: IF p_validate_only = FND_API.G_FALSE THEN
958: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
959: SET UAI.REVISION_ID = (SELECT MIR.REVISION_ID
960: FROM MTL_ITEM_REVISIONS MIR
961: WHERE MIR.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
962: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
963: AND MIR.REVISION = UAI.REVISION)
964: WHERE UAI.DATA_SET_ID = p_data_set_id

Line 969: FROM MTL_ITEM_REVISIONS MIR2

965: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
966: AND UAI.REVISION IS NOT NULL
967: AND UAI.REVISION_ID IS NULL
968: AND EXISTS (SELECT MIR2.REVISION_ID
969: FROM MTL_ITEM_REVISIONS MIR2
970: WHERE MIR2.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
971: AND MIR2.ORGANIZATION_ID = UAI.ORGANIZATION_ID
972: AND MIR2.REVISION = UAI.REVISION);
973: ELSE

Line 976: FROM MTL_ITEM_REVISIONS MIR

972: AND MIR2.REVISION = UAI.REVISION);
973: ELSE
974: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
975: SET UAI.REVISION_ID = NVL( (SELECT MIR.REVISION_ID
976: FROM MTL_ITEM_REVISIONS MIR
977: WHERE MIR.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
978: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
979: AND MIR.REVISION = UAI.REVISION
980: ),

Line 982: FROM MTL_ITEM_REVISIONS_INTERFACE miri

978: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
979: AND MIR.REVISION = UAI.REVISION
980: ),
981: (SELECT miri.REVISION_ID
982: FROM MTL_ITEM_REVISIONS_INTERFACE miri
983: WHERE miri.SET_PROCESS_ID = UAI.DATA_SET_ID
984: AND miri.PROCESS_FLAG = 1
985: AND miri.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
986: AND miri.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 996: FROM MTL_ITEM_REVISIONS MIR2

992: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
993: AND UAI.REVISION IS NOT NULL
994: AND UAI.REVISION_ID IS NULL
995: AND EXISTS (SELECT 'X'
996: FROM MTL_ITEM_REVISIONS MIR2
997: WHERE MIR2.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
998: AND MIR2.ORGANIZATION_ID = UAI.ORGANIZATION_ID
999: AND MIR2.REVISION = UAI.REVISION
1000: UNION ALL

Line 1002: FROM MTL_ITEM_REVISIONS_INTERFACE miri

998: AND MIR2.ORGANIZATION_ID = UAI.ORGANIZATION_ID
999: AND MIR2.REVISION = UAI.REVISION
1000: UNION ALL
1001: SELECT 'X'
1002: FROM MTL_ITEM_REVISIONS_INTERFACE miri
1003: WHERE miri.SET_PROCESS_ID = UAI.DATA_SET_ID
1004: AND miri.PROCESS_FLAG = 1
1005: AND miri.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1006: AND miri.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 1671: FROM MTL_ITEM_REVISIONS MIR

1667: IF p_validate_only = FND_API.G_FALSE THEN
1668: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1669: SET (UAI.PROG_INT_NUM3)
1670: = NVL((SELECT MIR.CURRENT_PHASE_ID
1671: FROM MTL_ITEM_REVISIONS MIR
1672: WHERE MIR.REVISION_ID = UAI.REVISION_ID
1673: ), UAI.PROG_INT_NUM3),
1674: PROG_INT_CHAR2 =
1675: NVL((SELECT 'Y'

Line 1676: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

1672: WHERE MIR.REVISION_ID = UAI.REVISION_ID
1673: ), UAI.PROG_INT_NUM3),
1674: PROG_INT_CHAR2 =
1675: NVL((SELECT 'Y'
1676: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
1677: WHERE MIRI.REVISION_ID = UAI.REVISION_ID
1678: AND MIRI.request_id = UAI.REQUEST_ID
1679: AND MIRI.TRANSACTION_TYPE = 'CREATE'
1680: AND MIRI.PROCESS_FLAG = 7

Line 1691: FROM MTL_ITEM_REVISIONS mir

1687: ELSE
1688: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1689: SET UAI.PROG_INT_NUM3
1690: = NVL((CASE WHEN EXISTS (SELECT 1
1691: FROM MTL_ITEM_REVISIONS mir
1692: WHERE mir.REVISION_ID = UAI.REVISION_ID
1693: )
1694: THEN (SELECT mir1.CURRENT_PHASE_ID
1695: FROM MTL_ITEM_REVISIONS mir1

Line 1695: FROM MTL_ITEM_REVISIONS mir1

1691: FROM MTL_ITEM_REVISIONS mir
1692: WHERE mir.REVISION_ID = UAI.REVISION_ID
1693: )
1694: THEN (SELECT mir1.CURRENT_PHASE_ID
1695: FROM MTL_ITEM_REVISIONS mir1
1696: WHERE mir1.REVISION_ID = UAI.REVISION_ID
1697: )
1698: ELSE (SELECT miri.CURRENT_PHASE_ID
1699: FROM MTL_ITEM_REVISIONS_INTERFACE miri

Line 1699: FROM MTL_ITEM_REVISIONS_INTERFACE miri

1695: FROM MTL_ITEM_REVISIONS mir1
1696: WHERE mir1.REVISION_ID = UAI.REVISION_ID
1697: )
1698: ELSE (SELECT miri.CURRENT_PHASE_ID
1699: FROM MTL_ITEM_REVISIONS_INTERFACE miri
1700: WHERE miri.REVISION_ID = UAI.REVISION_ID
1701: AND miri.SET_PROCESS_ID = UAI.DATA_SET_ID
1702: AND miri.PROCESS_FLAG = 1
1703: AND ROWNUM = 1

Line 1709: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI1

1705: END
1706: ), UAI.PROG_INT_NUM3),
1707: PROG_INT_CHAR2 =
1708: NVL((SELECT 'Y'
1709: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI1
1710: WHERE MIRI1.REVISION_ID = UAI.REVISION_ID
1711: AND MIRI1.SET_PROCESS_ID = UAI.DATA_SET_ID
1712: AND MIRI1.TRANSACTION_TYPE = 'CREATE'
1713: AND MIRI1.PROCESS_FLAG = 1