APPS.PA_WORK_TYPE_UPGRADE dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 10: pa_cost_distribution_lines_all

6: Updates Work Type Id on
7: pa_projects_all,
8: pa_tasks,
9: pa_expenditure_items_all,
10: pa_cost_distribution_lines_all
11:
12: Simultaneously, it also updates Tp Amt Type Code on
13: pa_expenditure_items_all,
14: pa_cc_dist_lines_all

Line 370: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP, pa_cost_distribution_lines_all CDL

366: AND EXP.orig_exp_txn_reference2 is not null
367: UNION ALL
368: SELECT /*+ parallel(ei) */ EI.ROWID, EI.expenditure_item_id, null
369: , CDL.system_reference1, EI.transaction_source, 'PODIST'
370: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP, pa_cost_distribution_lines_all CDL
371: WHERE EI.transaction_source IN ('Inventory Misc', 'Inventory', 'PJM_CSTBP_INV_ACCOUNTS'
372: ,'PJM_CSTBP_INV_NO_ACCOUNTS', 'Work In Process'
373: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'
374: ,'PJM_CSTBP_WIP_ACCOUNTS', 'PJM_CSTBP_WIP_NO_ACCOUNTS'

Line 632: FROM pa_cost_distribution_lines_all cdl,

628: dist.invoice_line_number doc_line_num,
629: NVL2(LTRIM(cdl.system_reference4, '0123456789'), NULL, cdl.system_reference4) doc_payment_id,
630: inv.invoice_type_lookup_code doc_type,
631: dist.line_type_lookup_code dist_type
632: FROM pa_cost_distribution_lines_all cdl,
633: pa_expenditure_items_all ei,
634: ap_invoice_distributions_all dist,
635: ap_invoices_all inv
636: WHERE cdl.expenditure_item_id = ei.expenditure_item_id

Line 680: FROM pa_cost_distribution_lines_all cdl,

676: to_number(cdl.system_reference3) doc_line_num,
677: null doc_payment_id,
678: rcv.destination_type_code doc_type,
679: rcv.transaction_type dist_type
680: FROM pa_cost_distribution_lines_all cdl,
681: pa_expenditure_items_all ei,
682: rcv_transactions rcv
683: WHERE cdl.expenditure_item_id = ei.expenditure_item_id
684: AND rcv.transaction_id = to_number(NVL2(LTRIM(cdl.system_reference4, '0123456789'), NULL, cdl.system_reference4))

Line 710: FROM pa_cost_distribution_lines_all cdl

706: AND ei.project_id = p_project_id
707: AND (ei.transaction_source in ('AP EXPENSE', 'AP INVOICE', 'INTERCOMPANY_AP_INVOICES', 'INTERPROJECT_AP_INVOICES', 'AP NRTAX',
708: 'AP VARIANCE', 'AP DISCOUNTS' ,'AP ERV') OR ei.transaction_source like 'PO %') /* changed for bug 9320194 */
709: AND NOT EXISTS ( SELECT NULL
710: FROM pa_cost_distribution_lines_all cdl
711: WHERE cdl.expenditure_item_id = ei.expenditure_item_id);
712:
713:
714: Cursor cur_upg_project is

Line 776: update pa_cost_distribution_lines_all

772: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of EI Records updated = '||l_rowcount);
773: commit;
774:
775: FORALL j in l_EIIdTab.first .. l_EIIdTab.last
776: update pa_cost_distribution_lines_all
777: set work_type_id = l_WtIdTab(j)
778: where Expenditure_Item_Id = l_EIIdTab(j)
779: and line_type = 'R';
780: