VIEW: APPS.PA_CUSTOMER_RECEIVER_PRJECTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'