DBA Data[Home] [Help]

APPS.PJI_FM_EXTR dependencies on PA_CUST_REV_DIST_LINES_ALL

Line 1273: , pa_cust_rev_dist_lines_all crdl

1269: , -1 AS CBS_ELEMENT_ID /* Added for CBS Changes */
1270: From PJI_FM_EXTR_DREVN drev
1271: , pa_agreements_all ag
1272: , pa_project_customers cust
1273: , pa_cust_rev_dist_lines_all crdl
1274: Where 1 = 1
1275: And drev.worker_id = p_worker_id
1276: And drev.project_id = crdl.project_id
1277: And drev.draft_revenue_num = crdl.draft_revenue_num

Line 1743: , pa_cust_rev_dist_lines_all crdl

1739: FROM
1740: PJI_FM_EXTR_DREVN drev
1741: , pa_agreements_all ag
1742: , pa_project_customers cust
1743: , pa_cust_rev_dist_lines_all crdl
1744: WHERE
1745: drev.worker_id = p_worker_id
1746: and drev.project_id = crdl.project_id
1747: and drev.draft_revenue_num = crdl.draft_revenue_num

Line 2290: , pa_cust_rev_dist_lines_all crdl

2286: , to_number(null) AS BILL_QUANTITY
2287: , ei.CBS_ELEMENT_ID AS CBS_ELEMENT_ID /* Added for CBS Changes */
2288: FROM
2289: PJI_FM_REXT_CRDL scope
2290: , pa_cust_rev_dist_lines_all crdl
2291: , pa_expenditure_items_all ei
2292: , pa_expenditures_all exp
2293: , pa_expenditure_types et
2294: WHERE