DBA Data[Home] [Help]

APPS.PJI_FM_EXTR dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 1280: , pa_expenditure_items_all ei

1276: And crdl.function_code NOT IN ('LRL','LRB','URL','URB')
1277: And drev.gl_date is not null
1278: And drev.pa_date is not null
1279: ) CnR
1280: , pa_expenditure_items_all ei
1281: , pa_expenditures_all exp
1282: , pa_expenditure_types et
1283: WHERE 1 = 1
1284: And CnR.expenditure_item_id = ei.expenditure_item_id

Line 2177: , pa_expenditure_items_all ei

2173: , 0) AS BILL_QUANTITY
2174: FROM
2175: PJI_FM_REXT_CDL scope
2176: , pa_cost_distribution_lines_all cdl
2177: , pa_expenditure_items_all ei
2178: , pa_expenditures_all exp
2179: , pa_expenditure_types et
2180: WHERE
2181: scope.worker_id = p_worker_id

Line 2279: , pa_expenditure_items_all ei

2275: , to_number(null) AS BILL_QUANTITY
2276: FROM
2277: PJI_FM_REXT_CRDL scope
2278: , pa_cust_rev_dist_lines_all crdl
2279: , pa_expenditure_items_all ei
2280: , pa_expenditures_all exp
2281: , pa_expenditure_types et
2282: WHERE
2283: scope.worker_id = p_worker_id