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_00200_AAD_S_000006_BC_PKG dependencies on FND_LOOKUP_VALUES

Line 65348: , fnd_lookup_values fvl7

65344: END source_meaning
65345: FROM xla_events_gt xet
65346: , AP_INVOICE_EXTRACT_HEADER_V h2
65347: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
65348: , fnd_lookup_values fvl7
65349: , fnd_lookup_values fvl12
65350: , fnd_lookup_values fvl17
65351: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
65352: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 65349: , fnd_lookup_values fvl12

65345: FROM xla_events_gt xet
65346: , AP_INVOICE_EXTRACT_HEADER_V h2
65347: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
65348: , fnd_lookup_values fvl7
65349: , fnd_lookup_values fvl12
65350: , fnd_lookup_values fvl17
65351: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
65352: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65353: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 65350: , fnd_lookup_values fvl17

65346: , AP_INVOICE_EXTRACT_HEADER_V h2
65347: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
65348: , fnd_lookup_values fvl7
65349: , fnd_lookup_values fvl12
65350: , fnd_lookup_values fvl17
65351: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
65352: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65353: AND xet.event_class_code = C_EVENT_CLASS_CODE
65354: AND h2.event_id = xet.event_id

Line 65701: , fnd_lookup_values fvl9

65697: FROM xla_events_gt xet
65698: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
65699: , ZX_AP_DEF_TAX_EXTRACT_V l4
65700: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
65701: , fnd_lookup_values fvl9
65702: , fnd_lookup_values fvl15
65703: , fnd_lookup_values fvl18
65704: , fnd_lookup_values fvl46
65705: , fnd_lookup_values fvl59

Line 65702: , fnd_lookup_values fvl15

65698: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
65699: , ZX_AP_DEF_TAX_EXTRACT_V l4
65700: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
65701: , fnd_lookup_values fvl9
65702: , fnd_lookup_values fvl15
65703: , fnd_lookup_values fvl18
65704: , fnd_lookup_values fvl46
65705: , fnd_lookup_values fvl59
65706: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)

Line 65703: , fnd_lookup_values fvl18

65699: , ZX_AP_DEF_TAX_EXTRACT_V l4
65700: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
65701: , fnd_lookup_values fvl9
65702: , fnd_lookup_values fvl15
65703: , fnd_lookup_values fvl18
65704: , fnd_lookup_values fvl46
65705: , fnd_lookup_values fvl59
65706: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
65707: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 65704: , fnd_lookup_values fvl46

65700: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
65701: , fnd_lookup_values fvl9
65702: , fnd_lookup_values fvl15
65703: , fnd_lookup_values fvl18
65704: , fnd_lookup_values fvl46
65705: , fnd_lookup_values fvl59
65706: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
65707: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65708: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 65705: , fnd_lookup_values fvl59

65701: , fnd_lookup_values fvl9
65702: , fnd_lookup_values fvl15
65703: , fnd_lookup_values fvl18
65704: , fnd_lookup_values fvl46
65705: , fnd_lookup_values fvl59
65706: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
65707: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65708: AND xet.event_class_code = C_EVENT_CLASS_CODE
65709: AND l1.event_id = xet.event_id

Line 65860: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

65856: l_balance_type_code VARCHAR2(1) :=NULL;
65857: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
65858:
65859: --
65860: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
65861: --
65862:
65863: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
65864: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 66052: , fnd_lookup_values fvl7

66048: , h2.INV_DOC_SEQUENCE_VALUE source_124
66049: FROM xla_events_gt xet
66050: , AP_INVOICE_EXTRACT_HEADER_V h2
66051: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
66052: , fnd_lookup_values fvl7
66053: , fnd_lookup_values fvl12
66054: , fnd_lookup_values fvl17
66055: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
66056: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 66053: , fnd_lookup_values fvl12

66049: FROM xla_events_gt xet
66050: , AP_INVOICE_EXTRACT_HEADER_V h2
66051: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
66052: , fnd_lookup_values fvl7
66053: , fnd_lookup_values fvl12
66054: , fnd_lookup_values fvl17
66055: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
66056: and xet.event_class_code = C_EVENT_CLASS_CODE
66057: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 66054: , fnd_lookup_values fvl17

66050: , AP_INVOICE_EXTRACT_HEADER_V h2
66051: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
66052: , fnd_lookup_values fvl7
66053: , fnd_lookup_values fvl12
66054: , fnd_lookup_values fvl17
66055: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
66056: and xet.event_class_code = C_EVENT_CLASS_CODE
66057: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
66058: AND h3.asp_org_id = h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 66161: , fnd_lookup_values fvl9

66157: FROM xla_events_gt xet
66158: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
66159: , ZX_AP_DEF_TAX_EXTRACT_V l4
66160: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
66161: , fnd_lookup_values fvl9
66162: , fnd_lookup_values fvl15
66163: , fnd_lookup_values fvl18
66164: , fnd_lookup_values fvl46
66165: , fnd_lookup_values fvl59

Line 66162: , fnd_lookup_values fvl15

66158: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
66159: , ZX_AP_DEF_TAX_EXTRACT_V l4
66160: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
66161: , fnd_lookup_values fvl9
66162: , fnd_lookup_values fvl15
66163: , fnd_lookup_values fvl18
66164: , fnd_lookup_values fvl46
66165: , fnd_lookup_values fvl59
66166: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 66163: , fnd_lookup_values fvl18

66159: , ZX_AP_DEF_TAX_EXTRACT_V l4
66160: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
66161: , fnd_lookup_values fvl9
66162: , fnd_lookup_values fvl15
66163: , fnd_lookup_values fvl18
66164: , fnd_lookup_values fvl46
66165: , fnd_lookup_values fvl59
66166: WHERE xet.event_id between x_first_event_id and x_last_event_id
66167: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 66164: , fnd_lookup_values fvl46

66160: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
66161: , fnd_lookup_values fvl9
66162: , fnd_lookup_values fvl15
66163: , fnd_lookup_values fvl18
66164: , fnd_lookup_values fvl46
66165: , fnd_lookup_values fvl59
66166: WHERE xet.event_id between x_first_event_id and x_last_event_id
66167: and xet.event_date between p_pad_start_date and p_pad_end_date
66168: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 66165: , fnd_lookup_values fvl59

66161: , fnd_lookup_values fvl9
66162: , fnd_lookup_values fvl15
66163: , fnd_lookup_values fvl18
66164: , fnd_lookup_values fvl46
66165: , fnd_lookup_values fvl59
66166: WHERE xet.event_id between x_first_event_id and x_last_event_id
66167: and xet.event_date between p_pad_start_date and p_pad_end_date
66168: and xet.event_class_code = C_EVENT_CLASS_CODE
66169: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 68206: , fnd_lookup_values fvl7

68202: END source_meaning
68203: FROM xla_events_gt xet
68204: , AP_INVOICE_EXTRACT_HEADER_V h2
68205: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68206: , fnd_lookup_values fvl7
68207: , fnd_lookup_values fvl12
68208: , fnd_lookup_values fvl17
68209: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
68210: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 68207: , fnd_lookup_values fvl12

68203: FROM xla_events_gt xet
68204: , AP_INVOICE_EXTRACT_HEADER_V h2
68205: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68206: , fnd_lookup_values fvl7
68207: , fnd_lookup_values fvl12
68208: , fnd_lookup_values fvl17
68209: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
68210: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68211: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 68208: , fnd_lookup_values fvl17

68204: , AP_INVOICE_EXTRACT_HEADER_V h2
68205: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68206: , fnd_lookup_values fvl7
68207: , fnd_lookup_values fvl12
68208: , fnd_lookup_values fvl17
68209: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
68210: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68211: AND xet.event_class_code = C_EVENT_CLASS_CODE
68212: AND h2.event_id = xet.event_id

Line 68554: , fnd_lookup_values fvl9

68550: FROM xla_events_gt xet
68551: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
68552: , ZX_AP_DEF_TAX_EXTRACT_V l4
68553: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
68554: , fnd_lookup_values fvl9
68555: , fnd_lookup_values fvl15
68556: , fnd_lookup_values fvl18
68557: , fnd_lookup_values fvl46
68558: , fnd_lookup_values fvl59

Line 68555: , fnd_lookup_values fvl15

68551: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
68552: , ZX_AP_DEF_TAX_EXTRACT_V l4
68553: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
68554: , fnd_lookup_values fvl9
68555: , fnd_lookup_values fvl15
68556: , fnd_lookup_values fvl18
68557: , fnd_lookup_values fvl46
68558: , fnd_lookup_values fvl59
68559: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)

Line 68556: , fnd_lookup_values fvl18

68552: , ZX_AP_DEF_TAX_EXTRACT_V l4
68553: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
68554: , fnd_lookup_values fvl9
68555: , fnd_lookup_values fvl15
68556: , fnd_lookup_values fvl18
68557: , fnd_lookup_values fvl46
68558: , fnd_lookup_values fvl59
68559: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
68560: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 68557: , fnd_lookup_values fvl46

68553: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
68554: , fnd_lookup_values fvl9
68555: , fnd_lookup_values fvl15
68556: , fnd_lookup_values fvl18
68557: , fnd_lookup_values fvl46
68558: , fnd_lookup_values fvl59
68559: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
68560: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68561: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 68558: , fnd_lookup_values fvl59

68554: , fnd_lookup_values fvl9
68555: , fnd_lookup_values fvl15
68556: , fnd_lookup_values fvl18
68557: , fnd_lookup_values fvl46
68558: , fnd_lookup_values fvl59
68559: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
68560: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68561: AND xet.event_class_code = C_EVENT_CLASS_CODE
68562: AND l1.event_id = xet.event_id

Line 68713: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

68709: l_balance_type_code VARCHAR2(1) :=NULL;
68710: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
68711:
68712: --
68713: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68714: --
68715:
68716: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
68717: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 68903: , fnd_lookup_values fvl7

68899: , h2.INV_DOC_SEQUENCE_VALUE source_124
68900: FROM xla_events_gt xet
68901: , AP_INVOICE_EXTRACT_HEADER_V h2
68902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68903: , fnd_lookup_values fvl7
68904: , fnd_lookup_values fvl12
68905: , fnd_lookup_values fvl17
68906: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68907: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 68904: , fnd_lookup_values fvl12

68900: FROM xla_events_gt xet
68901: , AP_INVOICE_EXTRACT_HEADER_V h2
68902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68903: , fnd_lookup_values fvl7
68904: , fnd_lookup_values fvl12
68905: , fnd_lookup_values fvl17
68906: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68907: and xet.event_class_code = C_EVENT_CLASS_CODE
68908: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 68905: , fnd_lookup_values fvl17

68901: , AP_INVOICE_EXTRACT_HEADER_V h2
68902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68903: , fnd_lookup_values fvl7
68904: , fnd_lookup_values fvl12
68905: , fnd_lookup_values fvl17
68906: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68907: and xet.event_class_code = C_EVENT_CLASS_CODE
68908: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
68909: AND h3.asp_org_id= h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 69011: , fnd_lookup_values fvl9

69007: FROM xla_events_gt xet
69008: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
69009: , ZX_AP_DEF_TAX_EXTRACT_V l4
69010: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
69011: , fnd_lookup_values fvl9
69012: , fnd_lookup_values fvl15
69013: , fnd_lookup_values fvl18
69014: , fnd_lookup_values fvl46
69015: , fnd_lookup_values fvl59

Line 69012: , fnd_lookup_values fvl15

69008: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
69009: , ZX_AP_DEF_TAX_EXTRACT_V l4
69010: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
69011: , fnd_lookup_values fvl9
69012: , fnd_lookup_values fvl15
69013: , fnd_lookup_values fvl18
69014: , fnd_lookup_values fvl46
69015: , fnd_lookup_values fvl59
69016: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 69013: , fnd_lookup_values fvl18

69009: , ZX_AP_DEF_TAX_EXTRACT_V l4
69010: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
69011: , fnd_lookup_values fvl9
69012: , fnd_lookup_values fvl15
69013: , fnd_lookup_values fvl18
69014: , fnd_lookup_values fvl46
69015: , fnd_lookup_values fvl59
69016: WHERE xet.event_id between x_first_event_id and x_last_event_id
69017: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 69014: , fnd_lookup_values fvl46

69010: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
69011: , fnd_lookup_values fvl9
69012: , fnd_lookup_values fvl15
69013: , fnd_lookup_values fvl18
69014: , fnd_lookup_values fvl46
69015: , fnd_lookup_values fvl59
69016: WHERE xet.event_id between x_first_event_id and x_last_event_id
69017: and xet.event_date between p_pad_start_date and p_pad_end_date
69018: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 69015: , fnd_lookup_values fvl59

69011: , fnd_lookup_values fvl9
69012: , fnd_lookup_values fvl15
69013: , fnd_lookup_values fvl18
69014: , fnd_lookup_values fvl46
69015: , fnd_lookup_values fvl59
69016: WHERE xet.event_id between x_first_event_id and x_last_event_id
69017: and xet.event_date between p_pad_start_date and p_pad_end_date
69018: and xet.event_class_code = C_EVENT_CLASS_CODE
69019: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 71044: , fnd_lookup_values fvl7

71040: END source_meaning
71041: FROM xla_events_gt xet
71042: , AP_INVOICE_EXTRACT_HEADER_V h2
71043: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71044: , fnd_lookup_values fvl7
71045: , fnd_lookup_values fvl12
71046: , fnd_lookup_values fvl17
71047: , fnd_lookup_values fvl68
71048: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

Line 71045: , fnd_lookup_values fvl12

71041: FROM xla_events_gt xet
71042: , AP_INVOICE_EXTRACT_HEADER_V h2
71043: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71044: , fnd_lookup_values fvl7
71045: , fnd_lookup_values fvl12
71046: , fnd_lookup_values fvl17
71047: , fnd_lookup_values fvl68
71048: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
71049: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 71046: , fnd_lookup_values fvl17

71042: , AP_INVOICE_EXTRACT_HEADER_V h2
71043: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71044: , fnd_lookup_values fvl7
71045: , fnd_lookup_values fvl12
71046: , fnd_lookup_values fvl17
71047: , fnd_lookup_values fvl68
71048: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
71049: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71050: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 71047: , fnd_lookup_values fvl68

71043: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71044: , fnd_lookup_values fvl7
71045: , fnd_lookup_values fvl12
71046: , fnd_lookup_values fvl17
71047: , fnd_lookup_values fvl68
71048: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
71049: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71050: AND xet.event_class_code = C_EVENT_CLASS_CODE
71051: AND h2.event_id = xet.event_id

Line 71407: , fnd_lookup_values fvl9

71403: FROM xla_events_gt xet
71404: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
71405: , ZX_AP_DEF_TAX_EXTRACT_V l4
71406: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
71407: , fnd_lookup_values fvl9
71408: , fnd_lookup_values fvl15
71409: , fnd_lookup_values fvl18
71410: , fnd_lookup_values fvl46
71411: , fnd_lookup_values fvl59

Line 71408: , fnd_lookup_values fvl15

71404: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
71405: , ZX_AP_DEF_TAX_EXTRACT_V l4
71406: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
71407: , fnd_lookup_values fvl9
71408: , fnd_lookup_values fvl15
71409: , fnd_lookup_values fvl18
71410: , fnd_lookup_values fvl46
71411: , fnd_lookup_values fvl59
71412: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)

Line 71409: , fnd_lookup_values fvl18

71405: , ZX_AP_DEF_TAX_EXTRACT_V l4
71406: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
71407: , fnd_lookup_values fvl9
71408: , fnd_lookup_values fvl15
71409: , fnd_lookup_values fvl18
71410: , fnd_lookup_values fvl46
71411: , fnd_lookup_values fvl59
71412: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
71413: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 71410: , fnd_lookup_values fvl46

71406: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
71407: , fnd_lookup_values fvl9
71408: , fnd_lookup_values fvl15
71409: , fnd_lookup_values fvl18
71410: , fnd_lookup_values fvl46
71411: , fnd_lookup_values fvl59
71412: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
71413: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71414: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 71411: , fnd_lookup_values fvl59

71407: , fnd_lookup_values fvl9
71408: , fnd_lookup_values fvl15
71409: , fnd_lookup_values fvl18
71410: , fnd_lookup_values fvl46
71411: , fnd_lookup_values fvl59
71412: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
71413: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71414: AND xet.event_class_code = C_EVENT_CLASS_CODE
71415: AND l1.event_id = xet.event_id

Line 71566: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

71562: l_balance_type_code VARCHAR2(1) :=NULL;
71563: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
71564:
71565: --
71566: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
71567: --
71568:
71569: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
71570: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 71765: , fnd_lookup_values fvl7

71761: , h2.INV_DOC_SEQUENCE_VALUE source_124
71762: FROM xla_events_gt xet
71763: , AP_INVOICE_EXTRACT_HEADER_V h2
71764: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71765: , fnd_lookup_values fvl7
71766: , fnd_lookup_values fvl12
71767: , fnd_lookup_values fvl17
71768: , fnd_lookup_values fvl68
71769: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 71766: , fnd_lookup_values fvl12

71762: FROM xla_events_gt xet
71763: , AP_INVOICE_EXTRACT_HEADER_V h2
71764: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71765: , fnd_lookup_values fvl7
71766: , fnd_lookup_values fvl12
71767: , fnd_lookup_values fvl17
71768: , fnd_lookup_values fvl68
71769: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
71770: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 71767: , fnd_lookup_values fvl17

71763: , AP_INVOICE_EXTRACT_HEADER_V h2
71764: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71765: , fnd_lookup_values fvl7
71766: , fnd_lookup_values fvl12
71767: , fnd_lookup_values fvl17
71768: , fnd_lookup_values fvl68
71769: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
71770: and xet.event_class_code = C_EVENT_CLASS_CODE
71771: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 71768: , fnd_lookup_values fvl68

71764: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71765: , fnd_lookup_values fvl7
71766: , fnd_lookup_values fvl12
71767: , fnd_lookup_values fvl17
71768: , fnd_lookup_values fvl68
71769: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
71770: and xet.event_class_code = C_EVENT_CLASS_CODE
71771: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
71772: AND h3.asp_org_id = h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 71880: , fnd_lookup_values fvl9

71876: FROM xla_events_gt xet
71877: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
71878: , ZX_AP_DEF_TAX_EXTRACT_V l4
71879: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
71880: , fnd_lookup_values fvl9
71881: , fnd_lookup_values fvl15
71882: , fnd_lookup_values fvl18
71883: , fnd_lookup_values fvl46
71884: , fnd_lookup_values fvl59

Line 71881: , fnd_lookup_values fvl15

71877: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
71878: , ZX_AP_DEF_TAX_EXTRACT_V l4
71879: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
71880: , fnd_lookup_values fvl9
71881: , fnd_lookup_values fvl15
71882: , fnd_lookup_values fvl18
71883: , fnd_lookup_values fvl46
71884: , fnd_lookup_values fvl59
71885: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 71882: , fnd_lookup_values fvl18

71878: , ZX_AP_DEF_TAX_EXTRACT_V l4
71879: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
71880: , fnd_lookup_values fvl9
71881: , fnd_lookup_values fvl15
71882: , fnd_lookup_values fvl18
71883: , fnd_lookup_values fvl46
71884: , fnd_lookup_values fvl59
71885: WHERE xet.event_id between x_first_event_id and x_last_event_id
71886: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 71883: , fnd_lookup_values fvl46

71879: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
71880: , fnd_lookup_values fvl9
71881: , fnd_lookup_values fvl15
71882: , fnd_lookup_values fvl18
71883: , fnd_lookup_values fvl46
71884: , fnd_lookup_values fvl59
71885: WHERE xet.event_id between x_first_event_id and x_last_event_id
71886: and xet.event_date between p_pad_start_date and p_pad_end_date
71887: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 71884: , fnd_lookup_values fvl59

71880: , fnd_lookup_values fvl9
71881: , fnd_lookup_values fvl15
71882: , fnd_lookup_values fvl18
71883: , fnd_lookup_values fvl46
71884: , fnd_lookup_values fvl59
71885: WHERE xet.event_id between x_first_event_id and x_last_event_id
71886: and xet.event_date between p_pad_start_date and p_pad_end_date
71887: and xet.event_class_code = C_EVENT_CLASS_CODE
71888: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 74188: , fnd_lookup_values fvl108

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)
74190: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74191: AND xet.event_class_code = C_EVENT_CLASS_CODE
74192: AND l1.event_id = xet.event_id

Line 74327: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

74323: l_balance_type_code VARCHAR2(1) :=NULL;
74324: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
74325:
74326: --
74327: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
74328: --
74329:
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;

Line 74561: , fnd_lookup_values fvl108

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
74563: and xet.event_date between p_pad_start_date and p_pad_end_date
74564: and xet.event_class_code = C_EVENT_CLASS_CODE
74565: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 75836: , fnd_lookup_values fvl17

75832: END source_meaning
75833: FROM xla_events_gt xet
75834: , AP_INVOICE_EXTRACT_HEADER_V h1
75835: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
75836: , fnd_lookup_values fvl17
75837: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
75838: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75839: AND xet.event_class_code = C_EVENT_CLASS_CODE
75840: AND h1.event_id = xet.event_id

Line 76115: , fnd_lookup_values fvl46

76111: FROM xla_events_gt xet
76112: , AP_PREPAYAPP_EXTRACT_DTLS_BC_V l2
76113: , ZX_AP_DEF_TAX_EXTRACT_V l4
76114: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
76115: , fnd_lookup_values fvl46
76116: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
76117: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76118: AND xet.event_class_code = C_EVENT_CLASS_CODE
76119: AND l2.event_id = xet.event_id

Line 76254: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

76250: l_balance_type_code VARCHAR2(1) :=NULL;
76251: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
76252:
76253: --
76254: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76255: --
76256:
76257: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76258: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76387: , fnd_lookup_values fvl17

76383: , h1.INV_DOC_SEQUENCE_VALUE source_124
76384: FROM xla_events_gt xet
76385: , AP_INVOICE_EXTRACT_HEADER_V h1
76386: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
76387: , fnd_lookup_values fvl17
76388: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76389: and xet.event_class_code = C_EVENT_CLASS_CODE
76390: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
76391: AND h3.asp_org_id = h1.ai_org_id AND fvl17.lookup_type(+) = 'YES_NO'

Line 76470: , fnd_lookup_values fvl46

76466: FROM xla_events_gt xet
76467: , AP_PREPAYAPP_EXTRACT_DTLS_BC_V l2
76468: , ZX_AP_DEF_TAX_EXTRACT_V l4
76469: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
76470: , fnd_lookup_values fvl46
76471: WHERE xet.event_id between x_first_event_id and x_last_event_id
76472: and xet.event_date between p_pad_start_date and p_pad_end_date
76473: and xet.event_class_code = C_EVENT_CLASS_CODE
76474: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 77478: , fnd_lookup_values fvl7

77474: END source_meaning
77475: FROM xla_events_gt xet
77476: , AP_INVOICE_EXTRACT_HEADER_V h2
77477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
77478: , fnd_lookup_values fvl7
77479: , fnd_lookup_values fvl12
77480: , fnd_lookup_values fvl17
77481: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
77482: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 77479: , fnd_lookup_values fvl12

77475: FROM xla_events_gt xet
77476: , AP_INVOICE_EXTRACT_HEADER_V h2
77477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
77478: , fnd_lookup_values fvl7
77479: , fnd_lookup_values fvl12
77480: , fnd_lookup_values fvl17
77481: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
77482: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77483: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 77480: , fnd_lookup_values fvl17

77476: , AP_INVOICE_EXTRACT_HEADER_V h2
77477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
77478: , fnd_lookup_values fvl7
77479: , fnd_lookup_values fvl12
77480: , fnd_lookup_values fvl17
77481: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
77482: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77483: AND xet.event_class_code = C_EVENT_CLASS_CODE
77484: AND h2.event_id = xet.event_id

Line 77831: , fnd_lookup_values fvl9

77827: FROM xla_events_gt xet
77828: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
77829: , ZX_AP_DEF_TAX_EXTRACT_V l4
77830: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
77831: , fnd_lookup_values fvl9
77832: , fnd_lookup_values fvl15
77833: , fnd_lookup_values fvl18
77834: , fnd_lookup_values fvl46
77835: , fnd_lookup_values fvl59

Line 77832: , fnd_lookup_values fvl15

77828: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
77829: , ZX_AP_DEF_TAX_EXTRACT_V l4
77830: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
77831: , fnd_lookup_values fvl9
77832: , fnd_lookup_values fvl15
77833: , fnd_lookup_values fvl18
77834: , fnd_lookup_values fvl46
77835: , fnd_lookup_values fvl59
77836: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)

Line 77833: , fnd_lookup_values fvl18

77829: , ZX_AP_DEF_TAX_EXTRACT_V l4
77830: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
77831: , fnd_lookup_values fvl9
77832: , fnd_lookup_values fvl15
77833: , fnd_lookup_values fvl18
77834: , fnd_lookup_values fvl46
77835: , fnd_lookup_values fvl59
77836: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
77837: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 77834: , fnd_lookup_values fvl46

77830: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
77831: , fnd_lookup_values fvl9
77832: , fnd_lookup_values fvl15
77833: , fnd_lookup_values fvl18
77834: , fnd_lookup_values fvl46
77835: , fnd_lookup_values fvl59
77836: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
77837: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77838: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 77835: , fnd_lookup_values fvl59

77831: , fnd_lookup_values fvl9
77832: , fnd_lookup_values fvl15
77833: , fnd_lookup_values fvl18
77834: , fnd_lookup_values fvl46
77835: , fnd_lookup_values fvl59
77836: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
77837: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77838: AND xet.event_class_code = C_EVENT_CLASS_CODE
77839: AND l1.event_id = xet.event_id

Line 77990: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

77986: l_balance_type_code VARCHAR2(1) :=NULL;
77987: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
77988:
77989: --
77990: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
77991: --
77992:
77993: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
77994: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 78182: , fnd_lookup_values fvl7

78178: , h2.INV_DOC_SEQUENCE_VALUE source_124
78179: FROM xla_events_gt xet
78180: , AP_INVOICE_EXTRACT_HEADER_V h2
78181: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
78182: , fnd_lookup_values fvl7
78183: , fnd_lookup_values fvl12
78184: , fnd_lookup_values fvl17
78185: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
78186: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 78183: , fnd_lookup_values fvl12

78179: FROM xla_events_gt xet
78180: , AP_INVOICE_EXTRACT_HEADER_V h2
78181: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
78182: , fnd_lookup_values fvl7
78183: , fnd_lookup_values fvl12
78184: , fnd_lookup_values fvl17
78185: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
78186: and xet.event_class_code = C_EVENT_CLASS_CODE
78187: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 78184: , fnd_lookup_values fvl17

78180: , AP_INVOICE_EXTRACT_HEADER_V h2
78181: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
78182: , fnd_lookup_values fvl7
78183: , fnd_lookup_values fvl12
78184: , fnd_lookup_values fvl17
78185: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
78186: and xet.event_class_code = C_EVENT_CLASS_CODE
78187: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
78188: AND h3.asp_org_id = h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 78291: , fnd_lookup_values fvl9

78287: FROM xla_events_gt xet
78288: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
78289: , ZX_AP_DEF_TAX_EXTRACT_V l4
78290: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
78291: , fnd_lookup_values fvl9
78292: , fnd_lookup_values fvl15
78293: , fnd_lookup_values fvl18
78294: , fnd_lookup_values fvl46
78295: , fnd_lookup_values fvl59

Line 78292: , fnd_lookup_values fvl15

78288: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
78289: , ZX_AP_DEF_TAX_EXTRACT_V l4
78290: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
78291: , fnd_lookup_values fvl9
78292: , fnd_lookup_values fvl15
78293: , fnd_lookup_values fvl18
78294: , fnd_lookup_values fvl46
78295: , fnd_lookup_values fvl59
78296: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 78293: , fnd_lookup_values fvl18

78289: , ZX_AP_DEF_TAX_EXTRACT_V l4
78290: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
78291: , fnd_lookup_values fvl9
78292: , fnd_lookup_values fvl15
78293: , fnd_lookup_values fvl18
78294: , fnd_lookup_values fvl46
78295: , fnd_lookup_values fvl59
78296: WHERE xet.event_id between x_first_event_id and x_last_event_id
78297: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 78294: , fnd_lookup_values fvl46

78290: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
78291: , fnd_lookup_values fvl9
78292: , fnd_lookup_values fvl15
78293: , fnd_lookup_values fvl18
78294: , fnd_lookup_values fvl46
78295: , fnd_lookup_values fvl59
78296: WHERE xet.event_id between x_first_event_id and x_last_event_id
78297: and xet.event_date between p_pad_start_date and p_pad_end_date
78298: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 78295: , fnd_lookup_values fvl59

78291: , fnd_lookup_values fvl9
78292: , fnd_lookup_values fvl15
78293: , fnd_lookup_values fvl18
78294: , fnd_lookup_values fvl46
78295: , fnd_lookup_values fvl59
78296: WHERE xet.event_id between x_first_event_id and x_last_event_id
78297: and xet.event_date between p_pad_start_date and p_pad_end_date
78298: and xet.event_class_code = C_EVENT_CLASS_CODE
78299: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 80488: , fnd_lookup_values fvl108

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)
80490: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80491: AND xet.event_class_code = C_EVENT_CLASS_CODE
80492: AND l1.event_id = xet.event_id

Line 80627: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

80623: l_balance_type_code VARCHAR2(1) :=NULL;
80624: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
80625:
80626: --
80627: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
80628: --
80629:
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;

Line 80843: , fnd_lookup_values fvl108

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
80845: and xet.event_date between p_pad_start_date and p_pad_end_date
80846: and xet.event_class_code = C_EVENT_CLASS_CODE
80847: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 82138: , fnd_lookup_values fvl108

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)
82140: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
82141: AND xet.event_class_code = C_EVENT_CLASS_CODE
82142: AND l1.event_id = xet.event_id

Line 82277: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

82273: l_balance_type_code VARCHAR2(1) :=NULL;
82274: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
82275:
82276: --
82277: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
82278: --
82279:
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;

Line 82484: , fnd_lookup_values fvl108

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
82486: and xet.event_date between p_pad_start_date and p_pad_end_date
82487: and xet.event_class_code = C_EVENT_CLASS_CODE
82488: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id