DBA Data[Home] [Help]

APPS.XLA_00200_AAD_S_000010_BC_PKG dependencies on PA_XLA_EXP_ORG_REF_V

Line 73900: WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'

73896: , CASE r
73897: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73898: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
73899: WHEN 3 THEN 'PA_XLA_TASK_REF_V'
73900: WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'
73901: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73902: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73903: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73904: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'

Line 74185: , PA_XLA_EXP_ORG_REF_V l2

74181: ELSE null
74182: END source_meaning
74183: FROM xla_events_gt xet
74184: , PA_XLA_BC_PKT_AP_DETAIL_V l1
74185: , PA_XLA_EXP_ORG_REF_V l2
74186: , PA_XLA_PROJECT_REF_V l3
74187: , PA_XLA_TASK_REF_V l4
74188: , fnd_lookup_values fvl108
74189: , (select rownum r from all_objects where rownum <= 51 and owner = p_apps_owner)

Line 74334: TYPE t_array_source_5 IS TABLE OF PA_XLA_EXP_ORG_REF_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

74330:
74331: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DOCUMENT_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74332: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
74333: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74334: TYPE t_array_source_5 IS TABLE OF PA_XLA_EXP_ORG_REF_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
74335: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
74336: TYPE t_array_source_21 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
74337: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74338: TYPE t_array_source_33 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 74558: , PA_XLA_EXP_ORG_REF_V l2

74554: , l1.PO_FIRST_SYS_TRANS_ID source_120
74555: , l1.PO_SECOND_DIST_ID source_121
74556: FROM xla_events_gt xet
74557: , PA_XLA_BC_PKT_AP_DETAIL_V l1
74558: , PA_XLA_EXP_ORG_REF_V l2
74559: , PA_XLA_PROJECT_REF_V l3
74560: , PA_XLA_TASK_REF_V l4
74561: , fnd_lookup_values fvl108
74562: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 80230: WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'

80226: , CASE r
80227: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80228: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
80229: WHEN 3 THEN 'PA_XLA_TASK_REF_V'
80230: WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'
80231: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80232: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80233: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80234: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'

Line 80485: , PA_XLA_EXP_ORG_REF_V l2

80481: ELSE null
80482: END source_meaning
80483: FROM xla_events_gt xet
80484: , PA_XLA_BC_PKT_AP_DETAIL_V l1
80485: , PA_XLA_EXP_ORG_REF_V l2
80486: , PA_XLA_PROJECT_REF_V l3
80487: , PA_XLA_TASK_REF_V l4
80488: , fnd_lookup_values fvl108
80489: , (select rownum r from all_objects where rownum <= 45 and owner = p_apps_owner)

Line 80634: TYPE t_array_source_5 IS TABLE OF PA_XLA_EXP_ORG_REF_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

80630:
80631: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DOCUMENT_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80632: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
80633: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER;
80634: TYPE t_array_source_5 IS TABLE OF PA_XLA_EXP_ORG_REF_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
80635: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
80636: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
80637: TYPE t_array_source_21 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
80638: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 80840: , PA_XLA_EXP_ORG_REF_V l2

80836: , l1.PA_FIRST_SYS_TRANS_ID source_113
80837: , l1.PA_SECOND_DIST_ID source_114
80838: FROM xla_events_gt xet
80839: , PA_XLA_BC_PKT_AP_DETAIL_V l1
80840: , PA_XLA_EXP_ORG_REF_V l2
80841: , PA_XLA_PROJECT_REF_V l3
80842: , PA_XLA_TASK_REF_V l4
80843: , fnd_lookup_values fvl108
80844: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 81895: WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'

81891: , CASE r
81892: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81893: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
81894: WHEN 3 THEN 'PA_XLA_TASK_REF_V'
81895: WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'
81896: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81897: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81898: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81899: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'

Line 82135: , PA_XLA_EXP_ORG_REF_V l2

82131: ELSE null
82132: END source_meaning
82133: FROM xla_events_gt xet
82134: , PA_XLA_BC_PKT_AP_DETAIL_V l1
82135: , PA_XLA_EXP_ORG_REF_V l2
82136: , PA_XLA_PROJECT_REF_V l3
82137: , PA_XLA_TASK_REF_V l4
82138: , fnd_lookup_values fvl108
82139: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)

Line 82284: TYPE t_array_source_5 IS TABLE OF PA_XLA_EXP_ORG_REF_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

82280:
82281: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DOCUMENT_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82282: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
82283: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER;
82284: TYPE t_array_source_5 IS TABLE OF PA_XLA_EXP_ORG_REF_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
82285: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
82286: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
82287: TYPE t_array_source_21 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
82288: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 82481: , PA_XLA_EXP_ORG_REF_V l2

82477: , l1.PA_FIRST_SYS_TRANS_ID source_113
82478: , l1.PA_SECOND_DIST_ID source_114
82479: FROM xla_events_gt xet
82480: , PA_XLA_BC_PKT_AP_DETAIL_V l1
82481: , PA_XLA_EXP_ORG_REF_V l2
82482: , PA_XLA_PROJECT_REF_V l3
82483: , PA_XLA_TASK_REF_V l4
82484: , fnd_lookup_values fvl108
82485: WHERE xet.event_id between x_first_event_id and x_last_event_id