VIEW: APPS.PER_MASS_MOVES_V

Source

View Text - Preformatted

SELECT MM.ROWID , MM.MASS_MOVE_ID , MM.BUSINESS_GROUP_ID , MM.EFFECTIVE_DATE , MM.NEW_ORGANIZATION_ID , ORG.NAME , MM.OLD_ORGANIZATION_ID , ORG2.NAME , MM.BATCH_RUN_NUMBER , MM.REASON , MM.STATUS FROM PER_MASS_MOVES MM, PER_ORGANIZATION_UNITS_V ORG, PER_ORGANIZATION_UNITS_V ORG2 WHERE MM.NEW_ORGANIZATION_ID = ORG.ORGANIZATION_ID AND MM.OLD_ORGANIZATION_ID = ORG2.ORGANIZATION_ID

View Text - HTML Formatted

SELECT MM.ROWID
, MM.MASS_MOVE_ID
, MM.BUSINESS_GROUP_ID
, MM.EFFECTIVE_DATE
, MM.NEW_ORGANIZATION_ID
, ORG.NAME
, MM.OLD_ORGANIZATION_ID
, ORG2.NAME
, MM.BATCH_RUN_NUMBER
, MM.REASON
, MM.STATUS
FROM PER_MASS_MOVES MM
, PER_ORGANIZATION_UNITS_V ORG
, PER_ORGANIZATION_UNITS_V ORG2
WHERE MM.NEW_ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND MM.OLD_ORGANIZATION_ID = ORG2.ORGANIZATION_ID