Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT "ORG_ACCOUNT".ACCOUNT_NUMBER AS "Account Number",
- "ORG_PERSON".ADDRESS_2 AS "Address",
- "ORG_ACCOUNT".DODAAC AS "Dodaac",
- "ORG_DODAAC".DRA AS "Dra",
- "ORG_PERSON".EMAIL AS "Email",
- "ORG_PERSON".FIRST_NAME AS "First Name",
- "ORG_PERSON".LAST_NAME AS "Last Name",
- "ORG_PERSON".LAST_TRAIN_DATE AS "Last Train Date",
- "ORG_PERSON".MIDDLE_NAME AS "Middle Name",
- "ORG_ALT_ACCOUNT_CUST".PERSON_ID AS "Alt Person Id",
- "ORG_ORG".ORG_NAME AS "Org Name",
- "ORG_ACCOUNT".PERSON_ID AS "Person Id",
- "ORG_PERSON".PHONE_COM AS "Phone Com",
- "ORG_PERSON".PHONE_DSN AS "Phone Dsn",
- "ORG_PERSON".RANK AS "Rank"
- FROM "ORG"."ORG_ACCOUNT" "ORG_ACCOUNT",
- "ORG"."ORG_DODAAC" "ORG_DODAAC",
- "ORG"."ORG_ORG" "ORG_ORG",
- "ORG"."ORG_PERSON" "ORG_PERSON"
- "ORG"."ORG_ALT_ACCOUNT_CUST" "ORG_ALT_ACCOUNT_CUST"
- WHERE ( ( "ORG_PERSON".PERSON_ID(+) = ORG_ALT_ACCOUNT_CUST".PERSON_ID )
- AND ( "ORG_ORG".ORG_ID = "ORG_ACCOUNT".ORG_ID )
- AND ( "ORG_PERSON".PERSON_ID = "ORG_ACCOUNT".PERSON_ID )
- AND ( "ORG_ALT_ACCOUNT_CUST".PERSON_ID = "ORG_ACCOUNT".PERSON_ID )
- AND ( "ORG_DODAAC".DODAAC = "ORG_ACCOUNT".DODAAC ) )
- AND ( UPPER("ORG_ACCOUNT".DODAAC) LIKE UPPER(:DODAAC)
- AND "ORG_DODAAC".DRA IN ( :P_DRA_ENTRIES)
- AND UPPER("ORG_ACCOUNT".DODAAC_COMMODITY) = UPPER('A') )
- ORDER BY "ORG_DODAAC".DRA ASC, "ORG_ACCOUNT".ACCOUNT_NUMBER ASC, "ORG_PERSON".LAST_NAME ASC
Add Comment
Please, Sign In to add comment