[Home] [Help]
View: PA_CUSTOMER_RECEIVER_PRJECTS_V
View Text
SELECT P.SEGMENT1
, A.TASK_NUMBER
, A.TASK_NAME
, A.TASK_ID
, I.CUSTOMER_ID
, PARTY.PARTY_NAME
, I.ORG_ID
, P.PROJECT_ID
FROM PA_TASKS A
, PA_PROJECTS_ALL P
, PA_IMPLEMENTATIONS_ALL I
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND A.PROJECT_ID = P.PROJECT_ID
AND A.RECEIVE_PROJECT_INVOICE_FLAG = 'Y'
AND A.CHARGEABLE_FLAG = 'Y'
AND I.ORG_ID = P.ORG_ID
AND I.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(P.PROJECT_STATUS_CODE
, 'NEW_TXNS') = 'Y'
Columns
Name |
SEGMENT1 |
TASK_NUMBER |
TASK_NAME |
TASK_ID |
CUSTOMER_ID |
CUSTOMER_NAME |
ORG_ID |
PROJECT_ID |