DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000005_BC_PKG dependencies on XLA_EVENTS_GT

Line 6071: FROM xla_events_gt xet

6067: WHEN 15 THEN fvl37.meaning
6068:
6069: ELSE null
6070: END source_meaning
6071: FROM xla_events_gt xet
6072: , CST_XLA_RCV_HEADERS_V h1
6073: , CST_XLA_RCV_REF_V h3
6074: , PO_DISTS_REF_V h4
6075: , PO_HEADERS_REF_V h5

Line 6188: FROM xla_events_gt xet

6184:
6185: ELSE null
6186: END source_value
6187: , null source_meaning
6188: FROM xla_events_gt xet
6189: , CST_XLA_RCV_LINES_V l2
6190: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
6191: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6192: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 6413: FROM xla_events_gt xet

6409: , h5.PURCH_ENCUMBRANCE_TYPE_ID source_19
6410: , h3.PO_DISTRIBUTION_ID source_26
6411: , h1.TRANSFER_TO_GL_INDICATOR source_37
6412: , fvl37.meaning source_37_meaning
6413: FROM xla_events_gt xet
6414: , CST_XLA_RCV_HEADERS_V h1
6415: , CST_XLA_RCV_REF_V h3
6416: , PO_DISTS_REF_V h4
6417: , PO_HEADERS_REF_V h5

Line 6469: FROM xla_events_gt xet

6465: ,xet.budgetary_control_flag
6466: , l2.LINE_NUMBER
6467: , l2.DISTRIBUTION_IDENTIFIER source_12
6468: , l2.RCV_ACCOUNTING_LINE_TYPE source_25
6469: FROM xla_events_gt xet
6470: , CST_XLA_RCV_LINES_V l2
6471: WHERE xet.event_id between x_first_event_id and x_last_event_id
6472: and xet.event_date between p_pad_start_date and p_pad_end_date
6473: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 7366: FROM xla_events_gt xet

7362: WHEN 15 THEN fvl37.meaning
7363:
7364: ELSE null
7365: END source_meaning
7366: FROM xla_events_gt xet
7367: , CST_XLA_INV_HEADERS_V h1
7368: , CST_XLA_INV_ORG_PARAMS_REF_V h3
7369: , CST_XLA_INV_REF_V h4
7370: , PO_REQ_DISTS_REF_V h5

Line 7484: FROM xla_events_gt xet

7480:
7481: ELSE null
7482: END source_value
7483: , null source_meaning
7484: FROM xla_events_gt xet
7485: , CST_XLA_INV_LINES_V l2
7486: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
7487: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7488: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 7709: FROM xla_events_gt xet

7705: , h5.REQ_BUDGET_ACCOUNT source_34
7706: , h6.REQ_ENCUMBRANCE_TYPE_ID source_35
7707: , h1.TRANSFER_TO_GL_INDICATOR source_37
7708: , fvl37.meaning source_37_meaning
7709: FROM xla_events_gt xet
7710: , CST_XLA_INV_HEADERS_V h1
7711: , CST_XLA_INV_ORG_PARAMS_REF_V h3
7712: , CST_XLA_INV_REF_V h4
7713: , PO_REQ_DISTS_REF_V h5

Line 7766: FROM xla_events_gt xet

7762: ,xet.budgetary_control_flag
7763: , l2.LINE_NUMBER
7764: , l2.DISTRIBUTION_IDENTIFIER source_12
7765: , l2.CURRENCY_CODE source_16
7766: FROM xla_events_gt xet
7767: , CST_XLA_INV_LINES_V l2
7768: WHERE xet.event_id between x_first_event_id and x_last_event_id
7769: and xet.event_date between p_pad_start_date and p_pad_end_date
7770: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 8629: FROM xla_events_gt xet

8625: WHEN 15 THEN fvl37.meaning
8626:
8627: ELSE null
8628: END source_meaning
8629: FROM xla_events_gt xet
8630: , CST_XLA_INV_HEADERS_V h1
8631: , CST_XLA_INV_ORG_PARAMS_REF_V h3
8632: , CST_XLA_INV_REF_V h4
8633: , PO_REQ_DISTS_REF_V h5

Line 8752: FROM xla_events_gt xet

8748:
8749: ELSE null
8750: END source_value
8751: , null source_meaning
8752: FROM xla_events_gt xet
8753: , CST_XLA_INV_LINES_V l2
8754: , (select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
8755: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
8756: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 8979: FROM xla_events_gt xet

8975: , h5.REQ_BUDGET_ACCOUNT source_34
8976: , h6.REQ_ENCUMBRANCE_TYPE_ID source_35
8977: , h1.TRANSFER_TO_GL_INDICATOR source_37
8978: , fvl37.meaning source_37_meaning
8979: FROM xla_events_gt xet
8980: , CST_XLA_INV_HEADERS_V h1
8981: , CST_XLA_INV_ORG_PARAMS_REF_V h3
8982: , CST_XLA_INV_REF_V h4
8983: , PO_REQ_DISTS_REF_V h5

Line 9037: FROM xla_events_gt xet

9033: , l2.LINE_NUMBER
9034: , l2.ACCOUNTING_LINE_TYPE_CODE source_6
9035: , l2.DISTRIBUTION_IDENTIFIER source_12
9036: , l2.CURRENCY_CODE source_16
9037: FROM xla_events_gt xet
9038: , CST_XLA_INV_LINES_V l2
9039: WHERE xet.event_id between x_first_event_id and x_last_event_id
9040: and xet.event_date between p_pad_start_date and p_pad_end_date
9041: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 9837: FROM xla_events_gt xet

9833: WHEN 2 THEN fvl37.meaning
9834:
9835: ELSE null
9836: END source_meaning
9837: FROM xla_events_gt xet
9838: , CST_XLA_INV_HEADERS_V h1
9839: , fnd_lookup_values fvl13
9840: , fnd_lookup_values fvl37
9841: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 9985: FROM xla_events_gt xet

9981:
9982: ELSE null
9983: END source_value
9984: , null source_meaning
9985: FROM xla_events_gt xet
9986: , CST_XLA_INV_LINES_V l2
9987: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
9988: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9989: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 10185: FROM xla_events_gt xet

10181: , h1.DISTRIBUTION_TYPE source_13
10182: , fvl13.meaning source_13_meaning
10183: , h1.TRANSFER_TO_GL_INDICATOR source_37
10184: , fvl37.meaning source_37_meaning
10185: FROM xla_events_gt xet
10186: , CST_XLA_INV_HEADERS_V h1
10187: , fnd_lookup_values fvl13
10188: , fnd_lookup_values fvl37
10189: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 10244: FROM xla_events_gt xet

10240: , l2.CURRENCY_CONVERSION_DATE source_21
10241: , l2.CURRENCY_CONVERSION_RATE source_22
10242: , l2.CURRENCY_CONVERSION_TYPE source_23
10243: , l2.ACCOUNTED_AMOUNT source_24
10244: FROM xla_events_gt xet
10245: , CST_XLA_INV_LINES_V l2
10246: WHERE xet.event_id between x_first_event_id and x_last_event_id
10247: and xet.event_date between p_pad_start_date and p_pad_end_date
10248: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 11015: FROM xla_events_gt xet

11011: WHEN 2 THEN fvl37.meaning
11012:
11013: ELSE null
11014: END source_meaning
11015: FROM xla_events_gt xet
11016: , CST_XLA_INV_HEADERS_V h1
11017: , fnd_lookup_values fvl13
11018: , fnd_lookup_values fvl37
11019: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 11163: FROM xla_events_gt xet

11159:
11160: ELSE null
11161: END source_value
11162: , null source_meaning
11163: FROM xla_events_gt xet
11164: , CST_XLA_INV_LINES_V l2
11165: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
11166: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11167: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 11363: FROM xla_events_gt xet

11359: , h1.DISTRIBUTION_TYPE source_13
11360: , fvl13.meaning source_13_meaning
11361: , h1.TRANSFER_TO_GL_INDICATOR source_37
11362: , fvl37.meaning source_37_meaning
11363: FROM xla_events_gt xet
11364: , CST_XLA_INV_HEADERS_V h1
11365: , fnd_lookup_values fvl13
11366: , fnd_lookup_values fvl37
11367: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 11422: FROM xla_events_gt xet

11418: , l2.CURRENCY_CONVERSION_DATE source_21
11419: , l2.CURRENCY_CONVERSION_RATE source_22
11420: , l2.CURRENCY_CONVERSION_TYPE source_23
11421: , l2.ACCOUNTED_AMOUNT source_24
11422: FROM xla_events_gt xet
11423: , CST_XLA_INV_LINES_V l2
11424: WHERE xet.event_id between x_first_event_id and x_last_event_id
11425: and xet.event_date between p_pad_start_date and p_pad_end_date
11426: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 12253: FROM xla_events_gt xet

12249: WHEN 14 THEN fvl37.meaning
12250:
12251: ELSE null
12252: END source_meaning
12253: FROM xla_events_gt xet
12254: , CST_XLA_RCV_HEADERS_V h1
12255: , CST_XLA_RCV_REF_V h3
12256: , PO_DISTS_REF_V h4
12257: , PO_HEADERS_REF_V h5

Line 12370: FROM xla_events_gt xet

12366:
12367: ELSE null
12368: END source_value
12369: , null source_meaning
12370: FROM xla_events_gt xet
12371: , CST_XLA_RCV_LINES_V l2
12372: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
12373: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
12374: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 12592: FROM xla_events_gt xet

12588: , h3.PO_DISTRIBUTION_ID source_26
12589: , h6.CST_PEA_ENC_UPG_OPTION source_27
12590: , h1.TRANSFER_TO_GL_INDICATOR source_37
12591: , fvl37.meaning source_37_meaning
12592: FROM xla_events_gt xet
12593: , CST_XLA_RCV_HEADERS_V h1
12594: , CST_XLA_RCV_REF_V h3
12595: , PO_DISTS_REF_V h4
12596: , PO_HEADERS_REF_V h5

Line 12648: FROM xla_events_gt xet

12644: ,xet.budgetary_control_flag
12645: , l2.LINE_NUMBER
12646: , l2.DISTRIBUTION_IDENTIFIER source_12
12647: , l2.RCV_ACCOUNTING_LINE_TYPE source_25
12648: FROM xla_events_gt xet
12649: , CST_XLA_RCV_LINES_V l2
12650: WHERE xet.event_id between x_first_event_id and x_last_event_id
12651: and xet.event_date between p_pad_start_date and p_pad_end_date
12652: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 13554: FROM xla_events_gt xet

13550: WHEN 15 THEN fvl37.meaning
13551:
13552: ELSE null
13553: END source_meaning
13554: FROM xla_events_gt xet
13555: , CST_XLA_INV_HEADERS_V h1
13556: , CST_XLA_INV_ORG_PARAMS_REF_V h3
13557: , CST_XLA_INV_REF_V h4
13558: , PO_DISTS_REF_V h5

Line 13677: FROM xla_events_gt xet

13673:
13674: ELSE null
13675: END source_value
13676: , null source_meaning
13677: FROM xla_events_gt xet
13678: , CST_XLA_INV_LINES_V l2
13679: , (select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
13680: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
13681: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 13904: FROM xla_events_gt xet

13900: , h7.CST_ENCUM_UPG_OPTION source_18
13901: , h6.PURCH_ENCUMBRANCE_TYPE_ID source_19
13902: , h1.TRANSFER_TO_GL_INDICATOR source_37
13903: , fvl37.meaning source_37_meaning
13904: FROM xla_events_gt xet
13905: , CST_XLA_INV_HEADERS_V h1
13906: , CST_XLA_INV_ORG_PARAMS_REF_V h3
13907: , CST_XLA_INV_REF_V h4
13908: , PO_DISTS_REF_V h5

Line 13962: FROM xla_events_gt xet

13958: , l2.LINE_NUMBER
13959: , l2.ACCOUNTING_LINE_TYPE_CODE source_6
13960: , l2.DISTRIBUTION_IDENTIFIER source_12
13961: , l2.CURRENCY_CODE source_16
13962: FROM xla_events_gt xet
13963: , CST_XLA_INV_LINES_V l2
13964: WHERE xet.event_id between x_first_event_id and x_last_event_id
13965: and xet.event_date between p_pad_start_date and p_pad_end_date
13966: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 15008: (p_msg => '# of events in xla_events_gt: '

15004: ,p_level => C_LEVEL_STATEMENT
15005: ,p_module => l_log_module);
15006:
15007: trace
15008: (p_msg => '# of events in xla_events_gt: '
15009: ||xla_context_pkg.get_event_count_context
15010: ,p_level => C_LEVEL_STATEMENT
15011: ,p_module => l_log_module);
15012: