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.PJM_TRANSFER_SPEC_CHARGES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 185: FROM AP_Invoice_Distributions AID

181: , AID.Accts_Pay_Code_Combination_Id
182: , AID.Line_Type_Lookup_Code
183: , AID.RCV_Transaction_Id
184: , AID.Po_Distribution_Id
185: FROM AP_Invoice_Distributions AID
186: WHERE NOT EXISTS (
187: SELECT 'x'
188: FROM AP_Invoice_Distributions AID2
189: WHERE AID2.Invoice_Id = AID.Invoice_ID

Line 188: FROM AP_Invoice_Distributions AID2

184: , AID.Po_Distribution_Id
185: FROM AP_Invoice_Distributions AID
186: WHERE NOT EXISTS (
187: SELECT 'x'
188: FROM AP_Invoice_Distributions AID2
189: WHERE AID2.Invoice_Id = AID.Invoice_ID
190: AND AID2.Line_Type_Lookup_Code = 'ITEM' )
191: AND nvl(AID.Tax_Recoverable_Flag, 'N') = 'N'
192: AND AID.Posted_Flag = 'Y'

Line 216: FROM AP_Invoice_Distributions AID

212: , AID.Accts_Pay_Code_Combination_Id
213: , AID.Line_Type_Lookup_Code
214: , AID2.RCV_Transaction_Id
215: , AID2.Po_Distribution_Id
216: FROM AP_Invoice_Distributions AID
217: , AP_Invoice_Distributions AID2
218: , AP_Chrg_Allocations ACA
219: WHERE EXISTS (
220: SELECT 'x'

Line 217: , AP_Invoice_Distributions AID2

213: , AID.Line_Type_Lookup_Code
214: , AID2.RCV_Transaction_Id
215: , AID2.Po_Distribution_Id
216: FROM AP_Invoice_Distributions AID
217: , AP_Invoice_Distributions AID2
218: , AP_Chrg_Allocations ACA
219: WHERE EXISTS (
220: SELECT 'x'
221: FROM AP_Invoice_Distributions

Line 221: FROM AP_Invoice_Distributions

217: , AP_Invoice_Distributions AID2
218: , AP_Chrg_Allocations ACA
219: WHERE EXISTS (
220: SELECT 'x'
221: FROM AP_Invoice_Distributions
222: WHERE Invoice_Id = AID.Invoice_ID
223: AND Line_Type_Lookup_Code = 'ITEM' )
224: AND nvl(AID.Tax_Recoverable_Flag, 'N') = 'N'
225: AND AID.Posted_Flag = 'Y'

Line 288: FROM AP_Invoice_Distributions AID

284: , AID.Accts_Pay_Code_Combination_Id
285: , AID.Line_Type_Lookup_Code
286: , AID.RCV_Transaction_Id
287: , AID.Po_Distribution_Id
288: FROM AP_Invoice_Distributions AID
289: WHERE NOT EXISTS (
290: SELECT 'x'
291: FROM AP_Invoice_Distributions AID2
292: WHERE AID2.Invoice_Id = AID.Invoice_ID

Line 291: FROM AP_Invoice_Distributions AID2

287: , AID.Po_Distribution_Id
288: FROM AP_Invoice_Distributions AID
289: WHERE NOT EXISTS (
290: SELECT 'x'
291: FROM AP_Invoice_Distributions AID2
292: WHERE AID2.Invoice_Id = AID.Invoice_ID
293: AND AID2.Line_Type_Lookup_Code = 'ITEM' )
294: AND nvl(AID.Tax_Recoverable_Flag, 'N') = 'N'
295: AND AID.Posted_Flag = 'Y'

Line 319: FROM AP_Invoice_Distributions AID

315: , AID.Accts_Pay_Code_Combination_Id
316: , AID.Line_Type_Lookup_Code
317: , AID2.RCV_Transaction_Id
318: , AID2.Po_Distribution_Id
319: FROM AP_Invoice_Distributions AID
320: , AP_Invoice_Distributions AID2
321: , AP_Chrg_Allocations ACA
322: WHERE EXISTS (
323: SELECT 'x'

Line 320: , AP_Invoice_Distributions AID2

316: , AID.Line_Type_Lookup_Code
317: , AID2.RCV_Transaction_Id
318: , AID2.Po_Distribution_Id
319: FROM AP_Invoice_Distributions AID
320: , AP_Invoice_Distributions AID2
321: , AP_Chrg_Allocations ACA
322: WHERE EXISTS (
323: SELECT 'x'
324: FROM AP_Invoice_Distributions

Line 324: FROM AP_Invoice_Distributions

320: , AP_Invoice_Distributions AID2
321: , AP_Chrg_Allocations ACA
322: WHERE EXISTS (
323: SELECT 'x'
324: FROM AP_Invoice_Distributions
325: WHERE Invoice_Id = AID.Invoice_ID
326: AND Line_Type_Lookup_Code = 'ITEM' )
327: AND nvl(AID.Tax_Recoverable_Flag, 'N') = 'N'
328: AND AID.Posted_Flag = 'Y'

Line 396: FROM AP_Invoice_Distributions AID

392: , AID.Accts_Pay_Code_Combination_Id
393: , AID.Line_Type_Lookup_Code
394: , AID.RCV_Transaction_Id
395: , AID.Po_Distribution_Id
396: FROM AP_Invoice_Distributions AID
397: WHERE NOT EXISTS (
398: SELECT 'x'
399: FROM AP_Invoice_Distributions AID2
400: WHERE AID2.Invoice_Id = AID.Invoice_ID

Line 399: FROM AP_Invoice_Distributions AID2

395: , AID.Po_Distribution_Id
396: FROM AP_Invoice_Distributions AID
397: WHERE NOT EXISTS (
398: SELECT 'x'
399: FROM AP_Invoice_Distributions AID2
400: WHERE AID2.Invoice_Id = AID.Invoice_ID
401: AND AID2.Line_Type_Lookup_Code = 'ITEM' )
402: AND nvl(AID.Tax_Recoverable_Flag, 'N') = 'N'
403: AND AID.Posted_Flag = 'Y'

Line 427: FROM AP_Invoice_Distributions AID

423: , AID.Accts_Pay_Code_Combination_Id
424: , AID.Line_Type_Lookup_Code
425: , AID2.RCV_Transaction_Id
426: , AID2.Po_Distribution_Id
427: FROM AP_Invoice_Distributions AID
428: , AP_Invoice_Distributions AID2
429: , AP_Chrg_Allocations ACA
430: WHERE EXISTS (
431: SELECT 'x'

Line 428: , AP_Invoice_Distributions AID2

424: , AID.Line_Type_Lookup_Code
425: , AID2.RCV_Transaction_Id
426: , AID2.Po_Distribution_Id
427: FROM AP_Invoice_Distributions AID
428: , AP_Invoice_Distributions AID2
429: , AP_Chrg_Allocations ACA
430: WHERE EXISTS (
431: SELECT 'x'
432: FROM AP_Invoice_Distributions

Line 432: FROM AP_Invoice_Distributions

428: , AP_Invoice_Distributions AID2
429: , AP_Chrg_Allocations ACA
430: WHERE EXISTS (
431: SELECT 'x'
432: FROM AP_Invoice_Distributions
433: WHERE Invoice_Id = AID.Invoice_ID
434: AND Line_Type_Lookup_Code = 'ITEM' )
435: AND nvl(AID.Tax_Recoverable_Flag, 'N') = 'N'
436: AND AID.Posted_Flag = 'Y'

Line 498: FROM AP_Invoice_Distributions AID

494: , AID.Accts_Pay_Code_Combination_Id
495: , AID.Line_Type_Lookup_Code
496: , AID.RCV_Transaction_Id
497: , AID.Po_Distribution_Id
498: FROM AP_Invoice_Distributions AID
499: WHERE NOT EXISTS (
500: SELECT 'x'
501: FROM AP_Invoice_Distributions AID2
502: WHERE AID2.Invoice_Id = AID.Invoice_ID

Line 501: FROM AP_Invoice_Distributions AID2

497: , AID.Po_Distribution_Id
498: FROM AP_Invoice_Distributions AID
499: WHERE NOT EXISTS (
500: SELECT 'x'
501: FROM AP_Invoice_Distributions AID2
502: WHERE AID2.Invoice_Id = AID.Invoice_ID
503: AND AID2.Line_Type_Lookup_Code = 'ITEM' )
504: AND nvl(AID.Tax_Recoverable_Flag, 'N') = 'N'
505: AND AID.Posted_Flag = 'Y'

Line 529: FROM AP_Invoice_Distributions AID

525: , AID.Accts_Pay_Code_Combination_Id
526: , AID.Line_Type_Lookup_Code
527: , AID2.RCV_Transaction_Id
528: , AID2.Po_Distribution_Id
529: FROM AP_Invoice_Distributions AID
530: , AP_Invoice_Distributions AID2
531: , AP_Chrg_Allocations ACA
532: WHERE EXISTS (
533: SELECT 'x'

Line 530: , AP_Invoice_Distributions AID2

526: , AID.Line_Type_Lookup_Code
527: , AID2.RCV_Transaction_Id
528: , AID2.Po_Distribution_Id
529: FROM AP_Invoice_Distributions AID
530: , AP_Invoice_Distributions AID2
531: , AP_Chrg_Allocations ACA
532: WHERE EXISTS (
533: SELECT 'x'
534: FROM AP_Invoice_Distributions

Line 534: FROM AP_Invoice_Distributions

530: , AP_Invoice_Distributions AID2
531: , AP_Chrg_Allocations ACA
532: WHERE EXISTS (
533: SELECT 'x'
534: FROM AP_Invoice_Distributions
535: WHERE Invoice_Id = AID.Invoice_ID
536: AND Line_Type_Lookup_Code = 'ITEM' )
537: AND nvl(AID.Tax_Recoverable_Flag, 'N') = 'N'
538: AND AID.Posted_Flag = 'Y'

Line 704: UPDATE AP_Invoice_distributions DIST

700: if ( l_expenditure_type is not null ) then
701:
702: l_progress := 40;
703:
704: UPDATE AP_Invoice_distributions DIST
705: SET DIST.PA_Addition_Flag =
706: DECODE(l_proj_status, 'PA_EX_PROJECT_CLOSED', 'P',
707: 'PA_EX_PROJECT_DATE', 'D',
708: 'PA_EXP_TASK_STATUS', 'C',

Line 865: AP_Invoice_Distributions DIST

861: , l_user_id
862: , SYSDATE
863: , l_user_id
864: FROM
865: AP_Invoice_Distributions DIST
866: , AP_Invoices INV
867: , PA_Tasks TASK
868: , HR_Organization_Units ORG
869: WHERE

Line 895: UPDATE AP_Invoice_Distributions

891:
892:
893: l_progress := 70;
894:
895: UPDATE AP_Invoice_Distributions
896: SET Pa_Addition_Flag = 'Y'
897: WHERE Pa_Addition_Flag = 'S'
898: AND Invoice_Id = InvRec.Invoice_Id
899: AND Distribution_Line_Number = InvRec.Distribution_Line_Number;

Line 903: UPDATE AP_Invoice_Distributions

899: AND Distribution_Line_Number = InvRec.Distribution_Line_Number;
900:
901: ELSE /* l_expenditure_type is not null */
902:
903: UPDATE AP_Invoice_Distributions
904: SET Pa_Addition_Flag = 'Y'
905: , Request_ID = l_request_id
906: WHERE Invoice_Id = InvRec.Invoice_Id
907: AND Distribution_Line_Number = InvRec.Distribution_Line_Number;

Line 996: UPDATE AP_Invoice_distributions DIST

992: if ( l_expenditure_type is not null ) then
993:
994: l_progress := 40;
995:
996: UPDATE AP_Invoice_distributions DIST
997: SET DIST.PA_Addition_Flag =
998: DECODE(l_proj_status, 'PA_EX_PROJECT_CLOSED', 'P',
999: 'PA_EX_PROJECT_DATE', 'D',
1000: 'PA_EXP_TASK_STATUS', 'C',

Line 1157: AP_Invoice_Distributions DIST

1153: , l_user_id
1154: , SYSDATE
1155: , l_user_id
1156: FROM
1157: AP_Invoice_Distributions DIST
1158: , AP_Invoices INV
1159: , PA_Tasks TASK
1160: , HR_Organization_Units ORG
1161: WHERE

Line 1187: UPDATE AP_Invoice_Distributions

1183:
1184:
1185: l_progress := 70;
1186:
1187: UPDATE AP_Invoice_Distributions
1188: SET Pa_Addition_Flag = 'Y'
1189: WHERE Pa_Addition_Flag = 'S'
1190: AND Invoice_Id = InvRec.Invoice_Id
1191: AND Distribution_Line_Number = InvRec.Distribution_Line_Number;

Line 1195: UPDATE AP_Invoice_Distributions

1191: AND Distribution_Line_Number = InvRec.Distribution_Line_Number;
1192:
1193: ELSE /* l_expenditure_type is not null */
1194:
1195: UPDATE AP_Invoice_Distributions
1196: SET Pa_Addition_Flag = 'Y'
1197: , Request_ID = l_request_id
1198: WHERE Invoice_Id = InvRec.Invoice_Id
1199: AND Distribution_Line_Number = InvRec.Distribution_Line_Number;