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.XLA_00201_AAD_S_000005_BC_PKG dependencies on PO_REQ_EXTRACT_DETAIL_V

Line 57139: WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57135: FROM (
57136: SELECT xet.event_id event_id
57137: , l1.line_number line_number
57138: , CASE r
57139: WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57140: WHEN 2 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57141: WHEN 3 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57142: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57143: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57140: WHEN 2 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57136: SELECT xet.event_id event_id
57137: , l1.line_number line_number
57138: , CASE r
57139: WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57140: WHEN 2 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57141: WHEN 3 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57142: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57143: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57144: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57141: WHEN 3 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57137: , l1.line_number line_number
57138: , CASE r
57139: WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57140: WHEN 2 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57141: WHEN 3 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57142: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57143: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57144: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57145: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57142: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57138: , CASE r
57139: WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57140: WHEN 2 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57141: WHEN 3 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57142: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57143: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57144: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57145: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57146: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57143: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57139: WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57140: WHEN 2 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57141: WHEN 3 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57142: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57143: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57144: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57145: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57146: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57147: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57144: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57140: WHEN 2 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57141: WHEN 3 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57142: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57143: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57144: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57145: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57146: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57147: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57148: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57145: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57141: WHEN 3 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57142: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57143: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57144: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57145: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57146: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57147: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57148: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57149: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57146: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57142: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57143: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57144: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57145: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57146: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57147: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57148: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57149: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57150: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57147: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57143: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57144: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57145: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57146: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57147: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57148: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57149: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57150: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57151: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57148: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57144: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57145: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57146: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57147: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57148: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57149: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57150: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57151: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57152: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57149: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57145: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57146: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57147: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57148: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57149: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57150: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57151: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57152: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57153: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57150: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57146: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57147: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57148: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57149: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57150: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57151: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57152: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57153: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57154: WHEN 16 THEN 'PO_REQ_LINES_REF_V'

Line 57151: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57147: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57148: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57149: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57150: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57151: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57152: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57153: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57154: WHEN 16 THEN 'PO_REQ_LINES_REF_V'
57155: WHEN 17 THEN 'PO_REQ_LINES_REF_V'

Line 57152: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57148: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57149: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57150: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57151: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57152: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57153: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57154: WHEN 16 THEN 'PO_REQ_LINES_REF_V'
57155: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
57156: WHEN 18 THEN 'PO_REQ_LINES_REF_V'

Line 57153: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57149: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57150: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57151: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57152: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57153: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57154: WHEN 16 THEN 'PO_REQ_LINES_REF_V'
57155: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
57156: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
57157: WHEN 19 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57157: WHEN 19 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57153: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57154: WHEN 16 THEN 'PO_REQ_LINES_REF_V'
57155: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
57156: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
57157: WHEN 19 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57158: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57159: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57160:
57161: ELSE null

Line 57158: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57154: WHEN 16 THEN 'PO_REQ_LINES_REF_V'
57155: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
57156: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
57157: WHEN 19 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57158: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57159: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57160:
57161: ELSE null
57162: END object_name

Line 57159: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'

57155: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
57156: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
57157: WHEN 19 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57158: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57159: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57160:
57161: ELSE null
57162: END object_name
57163: , CASE r

Line 57266: , PO_REQ_EXTRACT_DETAIL_V l1

57262: ELSE null
57263: END source_value
57264: , null source_meaning
57265: FROM xla_events_gt xet
57266: , PO_REQ_EXTRACT_DETAIL_V l1
57267: , PO_REQ_LINES_REF_V l3
57268: , (select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
57269: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57270: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 57409: TYPE t_array_source_7 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

57405: TYPE t_array_source_76 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%TYPE INDEX BY BINARY_INTEGER;
57406: TYPE t_array_source_79 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_80 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
57408:
57409: TYPE t_array_source_7 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_11 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
57411: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
57412: TYPE t_array_source_16 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_33 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 57410: TYPE t_array_source_11 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

57406: TYPE t_array_source_79 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_80 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
57408:
57409: TYPE t_array_source_7 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_11 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
57411: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
57412: TYPE t_array_source_16 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_33 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_34 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 57411: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;

57407: TYPE t_array_source_80 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
57408:
57409: TYPE t_array_source_7 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_11 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
57411: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
57412: TYPE t_array_source_16 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_33 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_34 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_35 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 57412: TYPE t_array_source_16 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

57408:
57409: TYPE t_array_source_7 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_11 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
57411: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
57412: TYPE t_array_source_16 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_33 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_34 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_35 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 57413: TYPE t_array_source_33 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;

57409: TYPE t_array_source_7 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_11 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
57411: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
57412: TYPE t_array_source_16 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_33 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_34 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_35 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_53 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 57414: TYPE t_array_source_34 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

57410: TYPE t_array_source_11 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
57411: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
57412: TYPE t_array_source_16 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_33 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_34 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_35 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_53 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_54 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 57415: TYPE t_array_source_35 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;

57411: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
57412: TYPE t_array_source_16 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_33 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_34 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_35 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_53 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_54 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_55 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 57416: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

57412: TYPE t_array_source_16 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_33 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_34 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_35 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_53 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_54 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_55 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_56 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 57417: TYPE t_array_source_53 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

57413: TYPE t_array_source_33 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_34 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_35 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_53 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_54 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_55 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_56 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
57421: TYPE t_array_source_57 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 57418: TYPE t_array_source_54 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

57414: TYPE t_array_source_34 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_35 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_53 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_54 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_55 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_56 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
57421: TYPE t_array_source_57 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
57422: TYPE t_array_source_58 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 57419: TYPE t_array_source_55 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

57415: TYPE t_array_source_35 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_53 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_54 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_55 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_56 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
57421: TYPE t_array_source_57 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
57422: TYPE t_array_source_58 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57423: TYPE t_array_source_60 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;

Line 57420: TYPE t_array_source_56 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

57416: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_53 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_54 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_55 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_56 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
57421: TYPE t_array_source_57 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
57422: TYPE t_array_source_58 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57423: TYPE t_array_source_60 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
57424: TYPE t_array_source_62 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 57421: TYPE t_array_source_57 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

57417: TYPE t_array_source_53 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_54 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_55 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_56 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
57421: TYPE t_array_source_57 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
57422: TYPE t_array_source_58 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57423: TYPE t_array_source_60 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
57424: TYPE t_array_source_62 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57425: TYPE t_array_source_63 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 57422: TYPE t_array_source_58 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

57418: TYPE t_array_source_54 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_55 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_56 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
57421: TYPE t_array_source_57 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
57422: TYPE t_array_source_58 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57423: TYPE t_array_source_60 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
57424: TYPE t_array_source_62 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57425: TYPE t_array_source_63 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57426: TYPE t_array_source_64 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 57423: TYPE t_array_source_60 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;

57419: TYPE t_array_source_55 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_56 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
57421: TYPE t_array_source_57 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
57422: TYPE t_array_source_58 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57423: TYPE t_array_source_60 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
57424: TYPE t_array_source_62 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57425: TYPE t_array_source_63 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57426: TYPE t_array_source_64 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57427: TYPE t_array_source_75 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 57427: TYPE t_array_source_75 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;

57423: TYPE t_array_source_60 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
57424: TYPE t_array_source_62 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57425: TYPE t_array_source_63 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57426: TYPE t_array_source_64 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57427: TYPE t_array_source_75 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
57428: TYPE t_array_source_77 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
57429: TYPE t_array_source_78 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
57430:
57431: l_array_source_9 t_array_source_9;

Line 57428: TYPE t_array_source_77 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

57424: TYPE t_array_source_62 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57425: TYPE t_array_source_63 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57426: TYPE t_array_source_64 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57427: TYPE t_array_source_75 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
57428: TYPE t_array_source_77 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
57429: TYPE t_array_source_78 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
57430:
57431: l_array_source_9 t_array_source_9;
57432: l_array_source_10 t_array_source_10;

Line 57429: TYPE t_array_source_78 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

57425: TYPE t_array_source_63 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57426: TYPE t_array_source_64 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57427: TYPE t_array_source_75 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
57428: TYPE t_array_source_77 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
57429: TYPE t_array_source_78 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
57430:
57431: l_array_source_9 t_array_source_9;
57432: l_array_source_10 t_array_source_10;
57433: l_array_source_76 t_array_source_76;

Line 57555: , PO_REQ_EXTRACT_DETAIL_V l1

57551: , l1.ADJUSTMENT_STATUS source_75
57552: , l1.REQ_ENCUM_UPG_OPTION source_77
57553: , l1.REQ_UPG_ENC_TYPE_ID source_78
57554: FROM xla_events_gt xet
57555: , PO_REQ_EXTRACT_DETAIL_V l1
57556: , PO_REQ_LINES_REF_V l3
57557: WHERE xet.event_id between x_first_event_id and x_last_event_id
57558: and xet.event_date between p_pad_start_date and p_pad_end_date
57559: and xet.event_class_code = C_EVENT_CLASS_CODE