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 359: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP, pa_cost_distribution_lines_all CDL

355: AND EXP.orig_exp_txn_reference2 is not null
356: UNION ALL
357: SELECT /*+ parallel(ei) */ EI.ROWID, EI.expenditure_item_id, null
358: , CDL.system_reference1, EI.transaction_source, 'PODIST'
359: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP, pa_cost_distribution_lines_all CDL
360: WHERE EI.transaction_source IN ('Inventory Misc', 'Inventory', 'PJM_CSTBP_INV_ACCOUNTS'
361: ,'PJM_CSTBP_INV_NO_ACCOUNTS', 'Work In Process'
362: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'
363: ,'PJM_CSTBP_WIP_ACCOUNTS', 'PJM_CSTBP_WIP_NO_ACCOUNTS'

Line 621: FROM pa_cost_distribution_lines_all cdl,

617: dist.invoice_line_number doc_line_num,
618: NVL2(LTRIM(cdl.system_reference4, '0123456789'), NULL, cdl.system_reference4) doc_payment_id,
619: inv.invoice_type_lookup_code doc_type,
620: dist.line_type_lookup_code dist_type
621: FROM pa_cost_distribution_lines_all cdl,
622: pa_expenditure_items_all ei,
623: ap_invoice_distributions_all dist,
624: ap_invoices_all inv
625: WHERE cdl.expenditure_item_id = ei.expenditure_item_id

Line 659: FROM pa_cost_distribution_lines_all cdl,

655: to_number(cdl.system_reference3) doc_line_num,
656: null doc_payment_id,
657: rcv.destination_type_code doc_type,
658: rcv.transaction_type dist_type
659: FROM pa_cost_distribution_lines_all cdl,
660: pa_expenditure_items_all ei,
661: rcv_transactions rcv
662: WHERE cdl.expenditure_item_id = ei.expenditure_item_id
663: AND rcv.transaction_id = to_number(NVL2(LTRIM(cdl.system_reference4, '0123456789'), NULL, cdl.system_reference4))

Line 688: FROM pa_cost_distribution_lines_all cdl

684: AND ei.expenditure_item_date between nvl(l_Txn_Date,ei.expenditure_item_date) AND sysdate
685: AND ei.project_id = p_project_id
686: AND (ei.transaction_source like 'AP %' OR ei.transaction_source like 'PO %')
687: AND NOT EXISTS ( SELECT NULL
688: FROM pa_cost_distribution_lines_all cdl
689: WHERE cdl.expenditure_item_id = ei.expenditure_item_id);
690:
691:
692: Cursor cur_upg_project is

Line 734: update pa_cost_distribution_lines_all

730: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of EI Records updated = '||l_rowcount);
731: commit;
732:
733: FORALL j in l_EIIdTab.first .. l_EIIdTab.last
734: update pa_cost_distribution_lines_all
735: set work_type_id = l_WtIdTab(j)
736: where Expenditure_Item_Id = l_EIIdTab(j)
737: and line_type = 'R';
738: