Guest User

Untitled

a guest
Dec 13th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.75 KB | None | 0 0
  1. SELECT "ORG_ACCOUNT".ACCOUNT_NUMBER AS "Account Number",
  2. "ORG_PERSON".ADDRESS_2 AS "Address",
  3. "ORG_ACCOUNT".DODAAC AS "Dodaac",
  4. "ORG_DODAAC".DRA AS "Dra",
  5. "ORG_PERSON".EMAIL AS "Email",
  6. "ORG_PERSON".FIRST_NAME AS "First Name",
  7. "ORG_PERSON".LAST_NAME AS "Last Name",
  8. "ORG_PERSON".LAST_TRAIN_DATE AS "Last Train Date",
  9. "ORG_PERSON".MIDDLE_NAME AS "Middle Name",
  10. "ORG_ALT_ACCOUNT_CUST".PERSON_ID AS "Alt Person Id",
  11. "ORG_ORG".ORG_NAME AS "Org Name",
  12. "ORG_ACCOUNT".PERSON_ID AS "Person Id",
  13. "ORG_PERSON".PHONE_COM AS "Phone Com",
  14. "ORG_PERSON".PHONE_DSN AS "Phone Dsn",
  15. "ORG_PERSON".RANK AS "Rank"
  16. FROM "ORG"."ORG_ACCOUNT" "ORG_ACCOUNT",
  17. "ORG"."ORG_DODAAC" "ORG_DODAAC",
  18. "ORG"."ORG_ORG" "ORG_ORG",
  19. "ORG"."ORG_PERSON" "ORG_PERSON"
  20. "ORG"."ORG_ALT_ACCOUNT_CUST" "ORG_ALT_ACCOUNT_CUST"
  21. WHERE ( ( "ORG_PERSON".PERSON_ID(+) = ORG_ALT_ACCOUNT_CUST".PERSON_ID )
  22. AND ( "ORG_ORG".ORG_ID = "ORG_ACCOUNT".ORG_ID )
  23. AND ( "ORG_PERSON".PERSON_ID = "ORG_ACCOUNT".PERSON_ID )
  24. AND ( "ORG_ALT_ACCOUNT_CUST".PERSON_ID = "ORG_ACCOUNT".PERSON_ID )
  25. AND ( "ORG_DODAAC".DODAAC = "ORG_ACCOUNT".DODAAC ) )
  26. AND ( UPPER("ORG_ACCOUNT".DODAAC) LIKE UPPER(:DODAAC)
  27. AND "ORG_DODAAC".DRA IN ( :P_DRA_ENTRIES)
  28. AND UPPER("ORG_ACCOUNT".DODAAC_COMMODITY) = UPPER('A') )
  29. ORDER BY "ORG_DODAAC".DRA ASC, "ORG_ACCOUNT".ACCOUNT_NUMBER ASC, "ORG_PERSON".LAST_NAME ASC
Add Comment
Please, Sign In to add comment