[Home] [Help]
View: PER_MASS_MOVES_V
Product: | PER - Human Resources |
Description: | Used to support user interface |
Implementation/DBA Data: |
APPS.PER_MASS_MOVES_V
|
View Text
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
Columns
Name |
ROW_ID |
MASS_MOVE_ID |
BUSINESS_GROUP_ID |
EFFECTIVE_DATE |
NEW_ORGANIZATION_ID |
NEW_ORGANIZATION |
SOURCE_ORGANIZATION_ID |
SOURCE_ORGANIZATION |
BATCH_RUN_NUMBER |
REASON |
STATUS |