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 297: from pa_expenditure_items_all ei

293: pk1_id,
294: worker_id,
295: pk2_id)
296: select /*+ parallel(ei) */ ei.rowid, ei.expenditure_item_id id, null , ei.task_id
297: from pa_expenditure_items_all ei
298: where trunc(ei.expenditure_item_date) >= trunc(l_Txn_Date)
299: and nvl(ei.org_id, -99) = nvl(p_org_id,nvl(ei.org_id,-99)) /* Changed for Bug #6129449 by anuragar */
300: and work_type_id is null;
301:

Line 342: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP

338: ,reference1
339: )
340: SELECT /*+ parallel(ei) */ EI.ROWID, EI.expenditure_item_id, null
341: , EI.orig_transaction_reference, EI.transaction_source, 'CCO'
342: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP
343: WHERE EI.transaction_source = NVL(P_Txn_Src, EI.transaction_source)
344: AND EI.transaction_source IN ('Inventory Misc', 'Inventory', 'PJM_CSTBP_INV_ACCOUNTS'
345: ,'PJM_CSTBP_INV_NO_ACCOUNTS', 'Work In Process'
346: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'

Line 356: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP

352: AND EXP.orig_exp_txn_reference1 is null
353: UNION ALL
354: SELECT /*+ parallel(ei) */ EI.ROWID, EI.expenditure_item_id, null
355: , EXP.orig_exp_txn_reference1, EI.transaction_source, 'PODIST'
356: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP
357: WHERE EI.transaction_source IN ('Inventory Misc', 'Inventory', 'PJM_CSTBP_INV_ACCOUNTS'
358: ,'PJM_CSTBP_INV_NO_ACCOUNTS', 'Work In Process'
359: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'
360: ,'PJM_CSTBP_WIP_ACCOUNTS', 'PJM_CSTBP_WIP_NO_ACCOUNTS'

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

596: Rows number := 1000;
597: l_rowcount number :=0;
598:
599: TYPE rowid_typ IS TABLE OF varchar2(30) ;
600: TYPE exp_item_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE;
601: TYPE vendor_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.vendor_id%TYPE;
602: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
603: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
604: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;

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

597: l_rowcount number :=0;
598:
599: TYPE rowid_typ IS TABLE OF varchar2(30) ;
600: TYPE exp_item_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE;
601: TYPE vendor_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.vendor_id%TYPE;
602: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
603: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
604: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
605: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;

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

598:
599: TYPE rowid_typ IS TABLE OF varchar2(30) ;
600: TYPE exp_item_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE;
601: TYPE vendor_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.vendor_id%TYPE;
602: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
603: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
604: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
605: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;
606: TYPE document_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_type%TYPE;

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

599: TYPE rowid_typ IS TABLE OF varchar2(30) ;
600: TYPE exp_item_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE;
601: TYPE vendor_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.vendor_id%TYPE;
602: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
603: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
604: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
605: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;
606: TYPE document_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_type%TYPE;
607: TYPE document_dist_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_type%TYPE;

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

600: TYPE exp_item_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE;
601: TYPE vendor_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.vendor_id%TYPE;
602: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
603: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
604: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
605: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;
606: TYPE document_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_type%TYPE;
607: TYPE document_dist_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_type%TYPE;
608:

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

601: TYPE vendor_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.vendor_id%TYPE;
602: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
603: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
604: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
605: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;
606: TYPE document_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_type%TYPE;
607: TYPE document_dist_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_type%TYPE;
608:
609: l_ei_rowid_tbl rowid_typ ;

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

602: TYPE doc_header_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_header_id%TYPE;
603: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
604: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
605: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;
606: TYPE document_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_type%TYPE;
607: TYPE document_dist_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_type%TYPE;
608:
609: l_ei_rowid_tbl rowid_typ ;
610: l_exp_item_id_tbl exp_item_id_typ;

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

603: TYPE doc_dist_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_id%TYPE;
604: TYPE doc_line_num_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_line_number%TYPE;
605: TYPE doc_payment_id_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_payment_id%TYPE;
606: TYPE document_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_type%TYPE;
607: TYPE document_dist_typ IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.document_distribution_type%TYPE;
608:
609: l_ei_rowid_tbl rowid_typ ;
610: l_exp_item_id_tbl exp_item_id_typ;
611: l_vendor_id_tbl vendor_id_typ;

Line 633: pa_expenditure_items_all ei,

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

Line 681: pa_expenditure_items_all ei,

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

Line 701: FROM pa_expenditure_items_all ei

697: -- Get all the uncosted VI related transactions to be upgraded.
698: CURSOR cur_uncosted_ei(p_project_id in number) IS
699: SELECT ei.rowid,
700: ei.expenditure_item_id
701: FROM pa_expenditure_items_all ei
702: WHERE ei.cost_distributed_flag = 'N'
703: ANd ei.document_header_id IS NULL
704: AND nvl(ei.historical_flag,'Y') = 'Y'
705: AND ei.expenditure_item_date between nvl(l_Txn_Date,ei.expenditure_item_date) AND sysdate

Line 726: pa_expenditure_items_all ei

722: SELECT ei.rowid,
723: ei.expenditure_item_id,
724: e.vendor_id
725: FROM pa_expenditures_all e,
726: pa_expenditure_items_all ei
727: WHERE e.expenditure_id =ei.expenditure_id
728: and ei.document_header_id is null
729: AND ei.cost_distributed_flag = 'Y'
730: AND NVL(EI.HISTORICAL_FLAG,'Y') = 'Y'

Line 765: update pa_expenditure_items_all

761: Exit;
762: End If;
763:
764: FORALL i in l_EIIdTab.first .. l_EIIdTab.last
765: update pa_expenditure_items_all
766: set work_type_id = l_WtIdTab(i),
767: tp_amt_type_code = l_WtTpAmtTab(i)
768: where Expenditure_Item_Id = l_EIIdTab(i);
769:

Line 838: update pa_expenditure_items_all

834: Exit;
835: End If;
836:
837: FORALL i in l_EIIdTab.first .. l_EIIdTab.last
838: update pa_expenditure_items_all
839: set inventory_item_id = l_InvItmIdTab(i)
840: ,wip_resource_id = l_WIPIdTab(i)
841: ,unit_of_measure = l_UOMTab(i)
842: where Expenditure_Item_Id = l_EIIdTab(i);

Line 910: UPDATE pa_expenditure_items_all ei

906:
907: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating EI columns -R12 ');
908:
909: FORALL i in l_ei_rowid_tbl.first..l_ei_rowid_tbl.last
910: UPDATE pa_expenditure_items_all ei
911: SET ei.vendor_id = l_vendor_id_tbl(i),
912: ei.last_update_date = sysdate,
913: ei.document_header_id = l_doc_header_id_tbl(i),
914: ei.document_distribution_id = l_doc_dist_id_tbl(i),

Line 935: UPDATE pa_expenditure_items_all ei

931: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating uncosted EI columns ');
932: -- Update the adjusted and uncosted expenditures. Bug#5381198.
933: FOR uncosted_ei in cur_uncosted_ei(upg_proj.project_id) LOOP
934:
935: UPDATE pa_expenditure_items_all ei
936: SET (ei.vendor_id,
937: ei.document_header_id,
938: ei.document_distribution_id,
939: ei.document_line_number,

Line 950: FROM pa_expenditure_items_all uei

946: uei.document_line_number,
947: uei.document_payment_id,
948: uei.document_type,
949: uei.document_distribution_type
950: FROM pa_expenditure_items_all uei
951: WHERE uei.document_header_id >0
952: START WITH uei.expenditure_item_id = uncosted_ei.expenditure_item_id
953: CONNECT BY PRIOR NVL(uei.adjusted_expenditure_item_id,uei.transferred_from_exp_item_id)
954: = uei.expenditure_item_id

Line 967: update pa_expenditure_items_all ei

963: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating costed BTC columns starts');
964:
965: FOR costed_btc in cur_ap_po_btc(upg_proj.project_id) LOOP
966:
967: update pa_expenditure_items_all ei
968: set ei.vendor_id=costed_btc.vendor_id,
969: ei.last_update_date = sysdate
970: where ei.rowid = costed_btc.rowid
971: and ei.expenditure_item_id = costed_btc.expenditure_item_id;