View: PA_CUSTOMER_RECEIVER_PRJECTS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.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