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_XLA_UPGRADE dependencies on PA_XLA_UPG_LINES_GT

Line 78: THEN INTO PA_XLA_UPG_LINES_GT

74: CCDL table which can result into the same cdl_line_num for a given expenditure_item_id */
75:
76:
77: INSERT WHEN cdl_line_type in ('R', 'D', 'BL', 'PC')
78: THEN INTO PA_XLA_UPG_LINES_GT
79: (legal_entity_id,
80: ledger_id,
81: org_id,
82: expenditure_item_id,

Line 127: THEN INTO PA_XLA_UPG_LINES_GT

123: DR_REFERENCE_2,
124: DR_REFERENCE_3
125: )
126: WHEN cdl_line_type in ('R', 'C', 'BL', 'PC')
127: THEN INTO PA_XLA_UPG_LINES_GT
128: (legal_entity_id,
129: ledger_id,
130: org_id,
131: expenditure_item_id,

Line 422: FROM PA_XLA_UPG_LINES_GT lines_gt

418: ledger_id,
419: legal_entity_id,
420: expenditure_item_id,
421: org_id
422: FROM PA_XLA_UPG_LINES_GT lines_gt
423: WHERE order_line_num = 1
424: AND ((p_mode = 'D') OR
425: (p_mode = 'R' AND
426: NOT EXISTS (SELECT null

Line 561: SELECT /+ USE_NL(ent_gt lines_gt) INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) /

557: grouped_line_type,
558: gl_date,
559: xla_ae_headers_s.nextval
560: )
561: SELECT /*+ USE_NL(ent_gt lines_gt) INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) */
562: lines_gt.expenditure_item_id,
563: ent_gt.entity_id,
564: lines_gt.grouped_line_type,
565: lines_gt.gl_date,

Line 571: FROM PA_XLA_UPG_LINES_GT lines_gt,

567: lines_gt.ledger_id,
568: lines_gt.legal_entity_id,
569: lines_gt.je_category,
570: lines_gt.event_type_code
571: FROM PA_XLA_UPG_LINES_GT lines_gt,
572: PA_XLA_UPG_ENTITIES_GT ent_gt
573: WHERE lines_gt.expenditure_item_id = ent_gt.expenditure_item_id
574: GROUP BY lines_gt.expenditure_item_id,
575: ent_gt.entity_id,

Line 719: (select /*+ USE_NL (event_gt lines_gt imp) INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1)

715: gl_date AS gl_date,
716: RANK() OVER (PARTITION BY header_id
717: ORDER BY expenditure_item_id, cdl_line_num, position) AS ae_line_num
718: FROM
719: (select /*+ USE_NL (event_gt lines_gt imp) INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1)
720: INDEX(imp, GL_IMPORT_REFERENCES_N3) */
721: lines_gt.position,
722: event_gt.header_id header_id,
723: event_gt.event_id event_id,

Line 758: from PA_XLA_UPG_LINES_GT lines_gt,

754: lines_gt.reference_2,
755: lines_gt.reference_3,
756: lines_gt.ledger_id,
757: lines_gt.gl_date
758: from PA_XLA_UPG_LINES_GT lines_gt,
759: PA_XLA_UPG_EVENTS_GT event_gt
760: where event_gt.expenditure_item_id = lines_gt.expenditure_item_id
761: and event_gt.event_date = lines_gt.gl_date
762: and event_gt.grouped_line_type = lines_gt.grouped_line_type

Line 780: and exists ( select /+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) /

776: and rownum = 1)
777: WHERE cdl.expenditure_item_id between l_start_eiid and l_end_eiid
778: and cdl.line_type in ( 'R','C','D')
779: and cdl.acct_event_id is null
780: and exists ( select /*+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) */
781: 1
782: from PA_XLA_UPG_LINES_GT lines_gt
783: where lines_gt.expenditure_item_id = cdl.expenditure_item_id
784: and lines_gt.cdl_line_num = cdl.line_num);

Line 782: from PA_XLA_UPG_LINES_GT lines_gt

778: and cdl.line_type in ( 'R','C','D')
779: and cdl.acct_event_id is null
780: and exists ( select /*+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) */
781: 1
782: from PA_XLA_UPG_LINES_GT lines_gt
783: where lines_gt.expenditure_item_id = cdl.expenditure_item_id
784: and lines_gt.cdl_line_num = cdl.line_num);
785:
786:

Line 799: and exists ( select /+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) /

795: and rownum = 1)
796: WHERE cdl.expenditure_item_id between l_start_eiid and l_end_eiid
797: and cdl.line_type in ('BL','PC')
798: and cdl.acct_event_id is null
799: and exists ( select /*+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) */
800: 1
801: from PA_XLA_UPG_LINES_GT lines_gt
802: where lines_gt.expenditure_item_id = cdl.expenditure_item_id
803: and lines_gt.cdl_line_num = cdl.line_num);

Line 801: from PA_XLA_UPG_LINES_GT lines_gt

797: and cdl.line_type in ('BL','PC')
798: and cdl.acct_event_id is null
799: and exists ( select /*+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) */
800: 1
801: from PA_XLA_UPG_LINES_GT lines_gt
802: where lines_gt.expenditure_item_id = cdl.expenditure_item_id
803: and lines_gt.cdl_line_num = cdl.line_num);
804:
805:

Line 931: THEN INTO PA_XLA_UPG_LINES_GT

927: l_rows_processed := 0;
928:
929:
930: INSERT WHEN cdl_line_type in ('R', 'D', 'BL', 'PC')
931: THEN INTO PA_XLA_UPG_LINES_GT
932: (legal_entity_id,
933: ledger_id,
934: org_id,
935: expenditure_item_id,

Line 988: THEN INTO PA_XLA_UPG_LINES_GT

984: DR_REFERENCE_2,
985: DR_REFERENCE_3
986: )
987: WHEN cdl_line_type in ('R', 'C', 'BL', 'PC')
988: THEN INTO PA_XLA_UPG_LINES_GT
989: (legal_entity_id,
990: ledger_id,
991: org_id,
992: expenditure_item_id,

Line 1265: from PA_XLA_UPG_LINES_GT lines_gt

1261: lines_gt.gl_period_name ,
1262: lines_gt.legal_entity_id,
1263: lines_gt.je_category,
1264: lines_gt.event_type_code
1265: from PA_XLA_UPG_LINES_GT lines_gt
1266: group by lines_gt.event_id,
1267: lines_gt.ledger_id,
1268: lines_gt.expenditure_item_id,
1269: lines_gt.entity_id,

Line 1414: INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) INDEX(imp, GL_IMPORT_REFERENCES_N3) */

1410: RANK() OVER (PARTITION BY header_id
1411: ORDER BY expenditure_item_id, cdl_line_num, position) AS ae_line_num
1412: FROM
1413: (select /*+ USE_NL (event_gt lines_gt imp)
1414: INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) INDEX(imp, GL_IMPORT_REFERENCES_N3) */
1415: lines_gt.position,
1416: event_gt.header_id,
1417: event_gt.event_id,
1418: lines_gt.code_combination_id,

Line 1455: from PA_XLA_UPG_LINES_GT lines_gt,

1451: lines_gt.reference_2,
1452: lines_gt.reference_3,
1453: lines_gt.ledger_id,
1454: lines_gt.gl_date
1455: from PA_XLA_UPG_LINES_GT lines_gt,
1456: PA_XLA_UPG_EVENTS_GT event_gt
1457: where event_gt.expenditure_item_id = lines_gt.expenditure_item_id
1458: and event_gt.event_date = lines_gt.gl_date
1459: and event_gt.ledger_id = lines_gt.ledger_id /* Added for bug 4919145 */

Line 1469: and exists ( select /+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) /

1465: pa_mc_cost_dist_lines_all mc
1466: SET mc.xla_migrated_flag = 'Y'
1467: WHERE mc.expenditure_item_id between l_start_eiid and l_end_eiid
1468: and mc.line_type in ('R','C','D')
1469: and exists ( select /*+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) */
1470: 1
1471: from PA_XLA_UPG_LINES_GT lines_gt
1472: where lines_gt.expenditure_item_id = mc.expenditure_item_id
1473: and lines_gt.cdl_line_num = mc.line_num);

Line 1471: from PA_XLA_UPG_LINES_GT lines_gt

1467: WHERE mc.expenditure_item_id between l_start_eiid and l_end_eiid
1468: and mc.line_type in ('R','C','D')
1469: and exists ( select /*+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) */
1470: 1
1471: from PA_XLA_UPG_LINES_GT lines_gt
1472: where lines_gt.expenditure_item_id = mc.expenditure_item_id
1473: and lines_gt.cdl_line_num = mc.line_num);
1474:
1475:

Line 1481: and exists ( select /+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) /

1477: pa_mc_cc_dist_lines_all mc
1478: SET mc.xla_migrated_flag = 'Y'
1479: WHERE mc.expenditure_item_id between l_start_eiid and l_end_eiid
1480: and mc.line_type in ('BL','PC')
1481: and exists ( select /*+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) */
1482: 1
1483: from PA_XLA_UPG_LINES_GT lines_gt
1484: where lines_gt.expenditure_item_id = mc.expenditure_item_id
1485: and lines_gt.cdl_line_num = mc.line_num);

Line 1483: from PA_XLA_UPG_LINES_GT lines_gt

1479: WHERE mc.expenditure_item_id between l_start_eiid and l_end_eiid
1480: and mc.line_type in ('BL','PC')
1481: and exists ( select /*+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) */
1482: 1
1483: from PA_XLA_UPG_LINES_GT lines_gt
1484: where lines_gt.expenditure_item_id = mc.expenditure_item_id
1485: and lines_gt.cdl_line_num = mc.line_num);
1486:
1487: