eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_WORK_TYPE_UPGRADE dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 9: pa_expenditure_items_all,

5:
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,

Line 13: pa_expenditure_items_all,

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
15: pa_draft_invoice_details_all
16:
17: In FP.M, it has been modified to support update

Line 19: on pa_expenditure_items_all

15: pa_draft_invoice_details_all
16:
17: In FP.M, it has been modified to support update
18: inventory_item_id, wip_resource_id, unit_of_measure
19: on pa_expenditure_items_all
20:
21: Parameters: IN
22: P_Num_Of_Processes : User given number, that many processes will be spawned
23: P_Worker_Id : Holds the worker id

Line 286: from pa_expenditure_items_all ei

282: pk1_id,
283: worker_id,
284: pk2_id)
285: select /*+ parallel(ei) */ ei.rowid, ei.expenditure_item_id id, null , ei.task_id
286: from pa_expenditure_items_all ei
287: where trunc(ei.expenditure_item_date) >= trunc(l_Txn_Date)
288: and nvl(ei.org_id, -99) = nvl(p_org_id,nvl(ei.org_id,-99)) /* Changed for Bug #6129449 by anuragar */
289: and work_type_id is null;
290:

Line 331: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP

327: ,reference1
328: )
329: SELECT /*+ parallel(ei) */ EI.ROWID, EI.expenditure_item_id, null
330: , EI.orig_transaction_reference, EI.transaction_source, 'CCO'
331: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP
332: WHERE EI.transaction_source = NVL(P_Txn_Src, EI.transaction_source)
333: AND EI.transaction_source IN ('Inventory Misc', 'Inventory', 'PJM_CSTBP_INV_ACCOUNTS'
334: ,'PJM_CSTBP_INV_NO_ACCOUNTS', 'Work In Process'
335: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'

Line 345: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP

341: AND EXP.orig_exp_txn_reference1 is null
342: UNION ALL
343: SELECT /*+ parallel(ei) */ EI.ROWID, EI.expenditure_item_id, null
344: , EXP.orig_exp_txn_reference1, EI.transaction_source, 'PODIST'
345: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP
346: WHERE EI.transaction_source IN ('Inventory Misc', 'Inventory', 'PJM_CSTBP_INV_ACCOUNTS'
347: ,'PJM_CSTBP_INV_NO_ACCOUNTS', 'Work In Process'
348: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'
349: ,'PJM_CSTBP_WIP_ACCOUNTS', 'PJM_CSTBP_WIP_NO_ACCOUNTS'

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 589: TYPE exp_item_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE;

585: Rows number := 1000;
586: l_rowcount number :=0;
587:
588: TYPE rowid_typ IS TABLE OF varchar2(30) ;
589: TYPE exp_item_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE;
590: TYPE vendor_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.vendor_id%TYPE;
591: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
592: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
593: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;

Line 590: TYPE vendor_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.vendor_id%TYPE;

586: l_rowcount number :=0;
587:
588: TYPE rowid_typ IS TABLE OF varchar2(30) ;
589: TYPE exp_item_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE;
590: TYPE vendor_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.vendor_id%TYPE;
591: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
592: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
593: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
594: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;

Line 591: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;

587:
588: TYPE rowid_typ IS TABLE OF varchar2(30) ;
589: TYPE exp_item_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE;
590: TYPE vendor_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.vendor_id%TYPE;
591: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
592: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
593: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
594: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;
595: TYPE document_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_type%TYPE;

Line 592: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;

588: TYPE rowid_typ IS TABLE OF varchar2(30) ;
589: TYPE exp_item_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE;
590: TYPE vendor_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.vendor_id%TYPE;
591: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
592: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
593: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
594: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;
595: TYPE document_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_type%TYPE;
596: TYPE document_dist_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_type%TYPE;

Line 593: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;

589: TYPE exp_item_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE;
590: TYPE vendor_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.vendor_id%TYPE;
591: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
592: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
593: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
594: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;
595: TYPE document_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_type%TYPE;
596: TYPE document_dist_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_type%TYPE;
597:

Line 594: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;

590: TYPE vendor_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.vendor_id%TYPE;
591: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
592: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
593: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
594: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;
595: TYPE document_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_type%TYPE;
596: TYPE document_dist_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_type%TYPE;
597:
598: l_ei_rowid_tbl rowid_typ ;

Line 595: TYPE document_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_type%TYPE;

591: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
592: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
593: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
594: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;
595: TYPE document_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_type%TYPE;
596: TYPE document_dist_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_type%TYPE;
597:
598: l_ei_rowid_tbl rowid_typ ;
599: l_exp_item_id_tbl exp_item_id_typ;

Line 596: TYPE document_dist_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_type%TYPE;

592: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
593: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
594: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;
595: TYPE document_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_type%TYPE;
596: TYPE document_dist_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_type%TYPE;
597:
598: l_ei_rowid_tbl rowid_typ ;
599: l_exp_item_id_tbl exp_item_id_typ;
600: l_vendor_id_tbl vendor_id_typ;

Line 622: pa_expenditure_items_all ei,

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
626: AND inv.invoice_id = to_number(cdl.system_reference2)

Line 660: pa_expenditure_items_all ei,

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))
664: AND rcv.po_distribution_id = to_number(cdl.system_reference3)

Line 680: FROM pa_expenditure_items_all ei

676: -- Get all the uncosted VI related transactions to be upgraded.
677: CURSOR cur_uncosted_ei(p_project_id in number) IS
678: SELECT ei.rowid,
679: ei.expenditure_item_id
680: FROM pa_expenditure_items_all ei
681: WHERE ei.cost_distributed_flag = 'N'
682: ANd ei.document_header_id IS NULL
683: AND nvl(ei.historical_flag,'Y') = 'Y'
684: AND ei.expenditure_item_date between nvl(l_Txn_Date,ei.expenditure_item_date) AND sysdate

Line 723: update pa_expenditure_items_all

719: Exit;
720: End If;
721:
722: FORALL i in l_EIIdTab.first .. l_EIIdTab.last
723: update pa_expenditure_items_all
724: set work_type_id = l_WtIdTab(i),
725: tp_amt_type_code = l_WtTpAmtTab(i)
726: where Expenditure_Item_Id = l_EIIdTab(i);
727:

Line 796: update pa_expenditure_items_all

792: Exit;
793: End If;
794:
795: FORALL i in l_EIIdTab.first .. l_EIIdTab.last
796: update pa_expenditure_items_all
797: set inventory_item_id = l_InvItmIdTab(i)
798: ,wip_resource_id = l_WIPIdTab(i)
799: ,unit_of_measure = l_UOMTab(i)
800: where Expenditure_Item_Id = l_EIIdTab(i);

Line 868: UPDATE pa_expenditure_items_all ei

864:
865: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating EI columns -R12 ');
866:
867: FORALL i in l_ei_rowid_tbl.first..l_ei_rowid_tbl.last
868: UPDATE pa_expenditure_items_all ei
869: SET ei.vendor_id = l_vendor_id_tbl(i),
870: ei.last_update_date = sysdate,
871: ei.document_header_id = l_doc_header_id_tbl(i),
872: ei.document_distribution_id = l_doc_dist_id_tbl(i),

Line 893: UPDATE pa_expenditure_items_all ei

889: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating uncosted EI columns ');
890: -- Update the adjusted and uncosted expenditures. Bug#5381198.
891: FOR uncosted_ei in cur_uncosted_ei(upg_proj.project_id) LOOP
892:
893: UPDATE pa_expenditure_items_all ei
894: SET (ei.vendor_id,
895: ei.document_header_id,
896: ei.document_distribution_id,
897: ei.document_line_number,

Line 908: FROM pa_expenditure_items_all uei

904: uei.document_line_number,
905: uei.document_payment_id,
906: uei.document_type,
907: uei.document_distribution_type
908: FROM pa_expenditure_items_all uei
909: WHERE uei.document_header_id >0
910: START WITH uei.expenditure_item_id = uncosted_ei.expenditure_item_id
911: CONNECT BY PRIOR NVL(uei.adjusted_expenditure_item_id,uei.transferred_from_exp_item_id)
912: = uei.expenditure_item_id