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

Line 152704: , fnd_lookup_values fvl10

152700: END source_meaning
152701: FROM xla_events_gt xet
152702: , AP_INVOICE_EXTRACT_HEADER_V h2
152703: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152704: , fnd_lookup_values fvl10
152705: , fnd_lookup_values fvl43
152706: , fnd_lookup_values fvl167
152707: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
152708: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 152705: , fnd_lookup_values fvl43

152701: FROM xla_events_gt xet
152702: , AP_INVOICE_EXTRACT_HEADER_V h2
152703: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152704: , fnd_lookup_values fvl10
152705: , fnd_lookup_values fvl43
152706: , fnd_lookup_values fvl167
152707: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
152708: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
152709: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 152706: , fnd_lookup_values fvl167

152702: , AP_INVOICE_EXTRACT_HEADER_V h2
152703: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152704: , fnd_lookup_values fvl10
152705: , fnd_lookup_values fvl43
152706: , fnd_lookup_values fvl167
152707: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
152708: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
152709: AND xet.event_class_code = C_EVENT_CLASS_CODE
152710: AND h2.event_id = xet.event_id

Line 153058: , fnd_lookup_values fvl17

153054: , AP_INVOICE_EXTRACT_DETAILS_V l1
153055: , AP_PO_HEADERS_EXTRACT_V l3
153056: , ZX_AP_DEF_TAX_EXTRACT_V l5
153057: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153058: , fnd_lookup_values fvl17
153059: , fnd_lookup_values fvl28
153060: , fnd_lookup_values fvl54
153061: , fnd_lookup_values fvl85
153062: , fnd_lookup_values fvl145

Line 153059: , fnd_lookup_values fvl28

153055: , AP_PO_HEADERS_EXTRACT_V l3
153056: , ZX_AP_DEF_TAX_EXTRACT_V l5
153057: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153058: , fnd_lookup_values fvl17
153059: , fnd_lookup_values fvl28
153060: , fnd_lookup_values fvl54
153061: , fnd_lookup_values fvl85
153062: , fnd_lookup_values fvl145
153063: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)

Line 153060: , fnd_lookup_values fvl54

153056: , ZX_AP_DEF_TAX_EXTRACT_V l5
153057: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153058: , fnd_lookup_values fvl17
153059: , fnd_lookup_values fvl28
153060: , fnd_lookup_values fvl54
153061: , fnd_lookup_values fvl85
153062: , fnd_lookup_values fvl145
153063: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
153064: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 153061: , fnd_lookup_values fvl85

153057: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153058: , fnd_lookup_values fvl17
153059: , fnd_lookup_values fvl28
153060: , fnd_lookup_values fvl54
153061: , fnd_lookup_values fvl85
153062: , fnd_lookup_values fvl145
153063: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
153064: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153065: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 153062: , fnd_lookup_values fvl145

153058: , fnd_lookup_values fvl17
153059: , fnd_lookup_values fvl28
153060: , fnd_lookup_values fvl54
153061: , fnd_lookup_values fvl85
153062: , fnd_lookup_values fvl145
153063: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
153064: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153065: AND xet.event_class_code = C_EVENT_CLASS_CODE
153066: AND l1.event_id = xet.event_id

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

153213: l_balance_type_code VARCHAR2(1) :=NULL;
153214: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
153215:
153216: --
153217: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153218: --
153219:
153220: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153221: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 153415: , fnd_lookup_values fvl10

153411: , h2.INV_DOC_SEQUENCE_VALUE source_173
153412: FROM xla_events_gt xet
153413: , AP_INVOICE_EXTRACT_HEADER_V h2
153414: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153415: , fnd_lookup_values fvl10
153416: , fnd_lookup_values fvl43
153417: , fnd_lookup_values fvl167
153418: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153419: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 153416: , fnd_lookup_values fvl43

153412: FROM xla_events_gt xet
153413: , AP_INVOICE_EXTRACT_HEADER_V h2
153414: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153415: , fnd_lookup_values fvl10
153416: , fnd_lookup_values fvl43
153417: , fnd_lookup_values fvl167
153418: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153419: and xet.event_class_code = C_EVENT_CLASS_CODE
153420: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 153417: , fnd_lookup_values fvl167

153413: , AP_INVOICE_EXTRACT_HEADER_V h2
153414: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153415: , fnd_lookup_values fvl10
153416: , fnd_lookup_values fvl43
153417: , fnd_lookup_values fvl167
153418: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153419: and xet.event_class_code = C_EVENT_CLASS_CODE
153420: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
153421: AND h4.asp_org_id = h2.ai_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 153525: , fnd_lookup_values fvl17

153521: , AP_INVOICE_EXTRACT_DETAILS_V l1
153522: , AP_PO_HEADERS_EXTRACT_V l3
153523: , ZX_AP_DEF_TAX_EXTRACT_V l5
153524: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153525: , fnd_lookup_values fvl17
153526: , fnd_lookup_values fvl28
153527: , fnd_lookup_values fvl54
153528: , fnd_lookup_values fvl85
153529: , fnd_lookup_values fvl145

Line 153526: , fnd_lookup_values fvl28

153522: , AP_PO_HEADERS_EXTRACT_V l3
153523: , ZX_AP_DEF_TAX_EXTRACT_V l5
153524: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153525: , fnd_lookup_values fvl17
153526: , fnd_lookup_values fvl28
153527: , fnd_lookup_values fvl54
153528: , fnd_lookup_values fvl85
153529: , fnd_lookup_values fvl145
153530: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 153527: , fnd_lookup_values fvl54

153523: , ZX_AP_DEF_TAX_EXTRACT_V l5
153524: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153525: , fnd_lookup_values fvl17
153526: , fnd_lookup_values fvl28
153527: , fnd_lookup_values fvl54
153528: , fnd_lookup_values fvl85
153529: , fnd_lookup_values fvl145
153530: WHERE xet.event_id between x_first_event_id and x_last_event_id
153531: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 153528: , fnd_lookup_values fvl85

153524: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153525: , fnd_lookup_values fvl17
153526: , fnd_lookup_values fvl28
153527: , fnd_lookup_values fvl54
153528: , fnd_lookup_values fvl85
153529: , fnd_lookup_values fvl145
153530: WHERE xet.event_id between x_first_event_id and x_last_event_id
153531: and xet.event_date between p_pad_start_date and p_pad_end_date
153532: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 153529: , fnd_lookup_values fvl145

153525: , fnd_lookup_values fvl17
153526: , fnd_lookup_values fvl28
153527: , fnd_lookup_values fvl54
153528: , fnd_lookup_values fvl85
153529: , fnd_lookup_values fvl145
153530: WHERE xet.event_id between x_first_event_id and x_last_event_id
153531: and xet.event_date between p_pad_start_date and p_pad_end_date
153532: and xet.event_class_code = C_EVENT_CLASS_CODE
153533: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 155952: , fnd_lookup_values fvl10

155948: END source_meaning
155949: FROM xla_events_gt xet
155950: , AP_INVOICE_EXTRACT_HEADER_V h2
155951: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
155952: , fnd_lookup_values fvl10
155953: , fnd_lookup_values fvl43
155954: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
155955: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
155956: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 155953: , fnd_lookup_values fvl43

155949: FROM xla_events_gt xet
155950: , AP_INVOICE_EXTRACT_HEADER_V h2
155951: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
155952: , fnd_lookup_values fvl10
155953: , fnd_lookup_values fvl43
155954: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
155955: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
155956: AND xet.event_class_code = C_EVENT_CLASS_CODE
155957: AND h2.event_id = xet.event_id

Line 156296: , fnd_lookup_values fvl17

156292: , AP_INVOICE_EXTRACT_DETAILS_V l1
156293: , AP_PO_HEADERS_EXTRACT_V l3
156294: , ZX_AP_DEF_TAX_EXTRACT_V l5
156295: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
156296: , fnd_lookup_values fvl17
156297: , fnd_lookup_values fvl28
156298: , fnd_lookup_values fvl54
156299: , fnd_lookup_values fvl85
156300: , fnd_lookup_values fvl145

Line 156297: , fnd_lookup_values fvl28

156293: , AP_PO_HEADERS_EXTRACT_V l3
156294: , ZX_AP_DEF_TAX_EXTRACT_V l5
156295: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
156296: , fnd_lookup_values fvl17
156297: , fnd_lookup_values fvl28
156298: , fnd_lookup_values fvl54
156299: , fnd_lookup_values fvl85
156300: , fnd_lookup_values fvl145
156301: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)

Line 156298: , fnd_lookup_values fvl54

156294: , ZX_AP_DEF_TAX_EXTRACT_V l5
156295: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
156296: , fnd_lookup_values fvl17
156297: , fnd_lookup_values fvl28
156298: , fnd_lookup_values fvl54
156299: , fnd_lookup_values fvl85
156300: , fnd_lookup_values fvl145
156301: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
156302: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 156299: , fnd_lookup_values fvl85

156295: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
156296: , fnd_lookup_values fvl17
156297: , fnd_lookup_values fvl28
156298: , fnd_lookup_values fvl54
156299: , fnd_lookup_values fvl85
156300: , fnd_lookup_values fvl145
156301: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
156302: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156303: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 156300: , fnd_lookup_values fvl145

156296: , fnd_lookup_values fvl17
156297: , fnd_lookup_values fvl28
156298: , fnd_lookup_values fvl54
156299: , fnd_lookup_values fvl85
156300: , fnd_lookup_values fvl145
156301: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
156302: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156303: AND xet.event_class_code = C_EVENT_CLASS_CODE
156304: AND l1.event_id = xet.event_id

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

156451: l_balance_type_code VARCHAR2(1) :=NULL;
156452: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
156453:
156454: --
156455: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
156456: --
156457:
156458: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156459: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 156646: , fnd_lookup_values fvl10

156642: , h2.INV_DOC_SEQUENCE_VALUE source_173
156643: FROM xla_events_gt xet
156644: , AP_INVOICE_EXTRACT_HEADER_V h2
156645: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
156646: , fnd_lookup_values fvl10
156647: , fnd_lookup_values fvl43
156648: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
156649: and xet.event_class_code = C_EVENT_CLASS_CODE
156650: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 156647: , fnd_lookup_values fvl43

156643: FROM xla_events_gt xet
156644: , AP_INVOICE_EXTRACT_HEADER_V h2
156645: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
156646: , fnd_lookup_values fvl10
156647: , fnd_lookup_values fvl43
156648: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
156649: and xet.event_class_code = C_EVENT_CLASS_CODE
156650: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
156651: AND h4.asp_org_id= h2.ai_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 156750: , fnd_lookup_values fvl17

156746: , AP_INVOICE_EXTRACT_DETAILS_V l1
156747: , AP_PO_HEADERS_EXTRACT_V l3
156748: , ZX_AP_DEF_TAX_EXTRACT_V l5
156749: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
156750: , fnd_lookup_values fvl17
156751: , fnd_lookup_values fvl28
156752: , fnd_lookup_values fvl54
156753: , fnd_lookup_values fvl85
156754: , fnd_lookup_values fvl145

Line 156751: , fnd_lookup_values fvl28

156747: , AP_PO_HEADERS_EXTRACT_V l3
156748: , ZX_AP_DEF_TAX_EXTRACT_V l5
156749: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
156750: , fnd_lookup_values fvl17
156751: , fnd_lookup_values fvl28
156752: , fnd_lookup_values fvl54
156753: , fnd_lookup_values fvl85
156754: , fnd_lookup_values fvl145
156755: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 156752: , fnd_lookup_values fvl54

156748: , ZX_AP_DEF_TAX_EXTRACT_V l5
156749: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
156750: , fnd_lookup_values fvl17
156751: , fnd_lookup_values fvl28
156752: , fnd_lookup_values fvl54
156753: , fnd_lookup_values fvl85
156754: , fnd_lookup_values fvl145
156755: WHERE xet.event_id between x_first_event_id and x_last_event_id
156756: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 156753: , fnd_lookup_values fvl85

156749: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
156750: , fnd_lookup_values fvl17
156751: , fnd_lookup_values fvl28
156752: , fnd_lookup_values fvl54
156753: , fnd_lookup_values fvl85
156754: , fnd_lookup_values fvl145
156755: WHERE xet.event_id between x_first_event_id and x_last_event_id
156756: and xet.event_date between p_pad_start_date and p_pad_end_date
156757: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 156754: , fnd_lookup_values fvl145

156750: , fnd_lookup_values fvl17
156751: , fnd_lookup_values fvl28
156752: , fnd_lookup_values fvl54
156753: , fnd_lookup_values fvl85
156754: , fnd_lookup_values fvl145
156755: WHERE xet.event_id between x_first_event_id and x_last_event_id
156756: and xet.event_date between p_pad_start_date and p_pad_end_date
156757: and xet.event_class_code = C_EVENT_CLASS_CODE
156758: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 159173: , fnd_lookup_values fvl10

159169: END source_meaning
159170: FROM xla_events_gt xet
159171: , AP_PAYMENT_EXTRACT_HEADER_V h2
159172: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
159173: , fnd_lookup_values fvl10
159174: , fnd_lookup_values fvl43
159175: , fnd_lookup_values fvl116
159176: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
159177: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 159174: , fnd_lookup_values fvl43

159170: FROM xla_events_gt xet
159171: , AP_PAYMENT_EXTRACT_HEADER_V h2
159172: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
159173: , fnd_lookup_values fvl10
159174: , fnd_lookup_values fvl43
159175: , fnd_lookup_values fvl116
159176: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
159177: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159178: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 159175: , fnd_lookup_values fvl116

159171: , AP_PAYMENT_EXTRACT_HEADER_V h2
159172: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
159173: , fnd_lookup_values fvl10
159174: , fnd_lookup_values fvl43
159175: , fnd_lookup_values fvl116
159176: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
159177: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159178: AND xet.event_class_code = C_EVENT_CLASS_CODE
159179: AND h2.event_id = xet.event_id

Line 159414: , fnd_lookup_values fvl28

159410: END source_meaning
159411: FROM xla_events_gt xet
159412: , AP_PAYMENT_EXTRACT_DETAILS_V l1
159413: , ZX_AP_DEF_TAX_EXTRACT_V l4
159414: , fnd_lookup_values fvl28
159415: , fnd_lookup_values fvl85
159416: , fnd_lookup_values fvl101
159417: , fnd_lookup_values fvl140
159418: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

Line 159415: , fnd_lookup_values fvl85

159411: FROM xla_events_gt xet
159412: , AP_PAYMENT_EXTRACT_DETAILS_V l1
159413: , ZX_AP_DEF_TAX_EXTRACT_V l4
159414: , fnd_lookup_values fvl28
159415: , fnd_lookup_values fvl85
159416: , fnd_lookup_values fvl101
159417: , fnd_lookup_values fvl140
159418: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
159419: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 159416: , fnd_lookup_values fvl101

159412: , AP_PAYMENT_EXTRACT_DETAILS_V l1
159413: , ZX_AP_DEF_TAX_EXTRACT_V l4
159414: , fnd_lookup_values fvl28
159415: , fnd_lookup_values fvl85
159416: , fnd_lookup_values fvl101
159417: , fnd_lookup_values fvl140
159418: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
159419: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159420: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 159417: , fnd_lookup_values fvl140

159413: , ZX_AP_DEF_TAX_EXTRACT_V l4
159414: , fnd_lookup_values fvl28
159415: , fnd_lookup_values fvl85
159416: , fnd_lookup_values fvl101
159417: , fnd_lookup_values fvl140
159418: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
159419: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159420: AND xet.event_class_code = C_EVENT_CLASS_CODE
159421: AND l1.event_id = xet.event_id

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

159564: l_balance_type_code VARCHAR2(1) :=NULL;
159565: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
159566:
159567: --
159568: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
159569: --
159570:
159571: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
159572: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 159733: , fnd_lookup_values fvl10

159729: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_176
159730: FROM xla_events_gt xet
159731: , AP_PAYMENT_EXTRACT_HEADER_V h2
159732: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
159733: , fnd_lookup_values fvl10
159734: , fnd_lookup_values fvl43
159735: , fnd_lookup_values fvl116
159736: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
159737: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 159734: , fnd_lookup_values fvl43

159730: FROM xla_events_gt xet
159731: , AP_PAYMENT_EXTRACT_HEADER_V h2
159732: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
159733: , fnd_lookup_values fvl10
159734: , fnd_lookup_values fvl43
159735: , fnd_lookup_values fvl116
159736: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
159737: and xet.event_class_code = C_EVENT_CLASS_CODE
159738: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 159735: , fnd_lookup_values fvl116

159731: , AP_PAYMENT_EXTRACT_HEADER_V h2
159732: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
159733: , fnd_lookup_values fvl10
159734: , fnd_lookup_values fvl43
159735: , fnd_lookup_values fvl116
159736: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
159737: and xet.event_class_code = C_EVENT_CLASS_CODE
159738: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
159739: AND h3.asp_org_id = h2.ac_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 159818: , fnd_lookup_values fvl28

159814: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_164
159815: FROM xla_events_gt xet
159816: , AP_PAYMENT_EXTRACT_DETAILS_V l1
159817: , ZX_AP_DEF_TAX_EXTRACT_V l4
159818: , fnd_lookup_values fvl28
159819: , fnd_lookup_values fvl85
159820: , fnd_lookup_values fvl101
159821: , fnd_lookup_values fvl140
159822: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 159819: , fnd_lookup_values fvl85

159815: FROM xla_events_gt xet
159816: , AP_PAYMENT_EXTRACT_DETAILS_V l1
159817: , ZX_AP_DEF_TAX_EXTRACT_V l4
159818: , fnd_lookup_values fvl28
159819: , fnd_lookup_values fvl85
159820: , fnd_lookup_values fvl101
159821: , fnd_lookup_values fvl140
159822: WHERE xet.event_id between x_first_event_id and x_last_event_id
159823: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 159820: , fnd_lookup_values fvl101

159816: , AP_PAYMENT_EXTRACT_DETAILS_V l1
159817: , ZX_AP_DEF_TAX_EXTRACT_V l4
159818: , fnd_lookup_values fvl28
159819: , fnd_lookup_values fvl85
159820: , fnd_lookup_values fvl101
159821: , fnd_lookup_values fvl140
159822: WHERE xet.event_id between x_first_event_id and x_last_event_id
159823: and xet.event_date between p_pad_start_date and p_pad_end_date
159824: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 159821: , fnd_lookup_values fvl140

159817: , ZX_AP_DEF_TAX_EXTRACT_V l4
159818: , fnd_lookup_values fvl28
159819: , fnd_lookup_values fvl85
159820: , fnd_lookup_values fvl101
159821: , fnd_lookup_values fvl140
159822: WHERE xet.event_id between x_first_event_id and x_last_event_id
159823: and xet.event_date between p_pad_start_date and p_pad_end_date
159824: and xet.event_class_code = C_EVENT_CLASS_CODE
159825: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 161473: , fnd_lookup_values fvl10

161469: END source_meaning
161470: FROM xla_events_gt xet
161471: , AP_INVOICE_EXTRACT_HEADER_V h2
161472: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161473: , fnd_lookup_values fvl10
161474: , fnd_lookup_values fvl43
161475: , fnd_lookup_values fvl167
161476: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
161477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 161474: , fnd_lookup_values fvl43

161470: FROM xla_events_gt xet
161471: , AP_INVOICE_EXTRACT_HEADER_V h2
161472: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161473: , fnd_lookup_values fvl10
161474: , fnd_lookup_values fvl43
161475: , fnd_lookup_values fvl167
161476: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
161477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161478: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 161475: , fnd_lookup_values fvl167

161471: , AP_INVOICE_EXTRACT_HEADER_V h2
161472: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161473: , fnd_lookup_values fvl10
161474: , fnd_lookup_values fvl43
161475: , fnd_lookup_values fvl167
161476: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
161477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161478: AND xet.event_class_code = C_EVENT_CLASS_CODE
161479: AND h2.event_id = xet.event_id

Line 161837: , fnd_lookup_values fvl17

161833: , AP_INVOICE_EXTRACT_DETAILS_V l1
161834: , AP_PO_HEADERS_EXTRACT_V l3
161835: , ZX_AP_DEF_TAX_EXTRACT_V l5
161836: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
161837: , fnd_lookup_values fvl17
161838: , fnd_lookup_values fvl28
161839: , fnd_lookup_values fvl54
161840: , fnd_lookup_values fvl85
161841: , fnd_lookup_values fvl145

Line 161838: , fnd_lookup_values fvl28

161834: , AP_PO_HEADERS_EXTRACT_V l3
161835: , ZX_AP_DEF_TAX_EXTRACT_V l5
161836: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
161837: , fnd_lookup_values fvl17
161838: , fnd_lookup_values fvl28
161839: , fnd_lookup_values fvl54
161840: , fnd_lookup_values fvl85
161841: , fnd_lookup_values fvl145
161842: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)

Line 161839: , fnd_lookup_values fvl54

161835: , ZX_AP_DEF_TAX_EXTRACT_V l5
161836: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
161837: , fnd_lookup_values fvl17
161838: , fnd_lookup_values fvl28
161839: , fnd_lookup_values fvl54
161840: , fnd_lookup_values fvl85
161841: , fnd_lookup_values fvl145
161842: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
161843: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 161840: , fnd_lookup_values fvl85

161836: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
161837: , fnd_lookup_values fvl17
161838: , fnd_lookup_values fvl28
161839: , fnd_lookup_values fvl54
161840: , fnd_lookup_values fvl85
161841: , fnd_lookup_values fvl145
161842: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
161843: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161844: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 161841: , fnd_lookup_values fvl145

161837: , fnd_lookup_values fvl17
161838: , fnd_lookup_values fvl28
161839: , fnd_lookup_values fvl54
161840: , fnd_lookup_values fvl85
161841: , fnd_lookup_values fvl145
161842: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
161843: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161844: AND xet.event_class_code = C_EVENT_CLASS_CODE
161845: AND l1.event_id = xet.event_id

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

161992: l_balance_type_code VARCHAR2(1) :=NULL;
161993: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
161994:
161995: --
161996: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
161997: --
161998:
161999: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162000: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 162198: , fnd_lookup_values fvl10

162194: , h2.INV_DOC_SEQUENCE_VALUE source_173
162195: FROM xla_events_gt xet
162196: , AP_INVOICE_EXTRACT_HEADER_V h2
162197: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162198: , fnd_lookup_values fvl10
162199: , fnd_lookup_values fvl43
162200: , fnd_lookup_values fvl167
162201: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162202: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 162199: , fnd_lookup_values fvl43

162195: FROM xla_events_gt xet
162196: , AP_INVOICE_EXTRACT_HEADER_V h2
162197: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162198: , fnd_lookup_values fvl10
162199: , fnd_lookup_values fvl43
162200: , fnd_lookup_values fvl167
162201: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162202: and xet.event_class_code = C_EVENT_CLASS_CODE
162203: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 162200: , fnd_lookup_values fvl167

162196: , AP_INVOICE_EXTRACT_HEADER_V h2
162197: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162198: , fnd_lookup_values fvl10
162199: , fnd_lookup_values fvl43
162200: , fnd_lookup_values fvl167
162201: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162202: and xet.event_class_code = C_EVENT_CLASS_CODE
162203: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
162204: AND h4.asp_org_id = h2.ai_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 162310: , fnd_lookup_values fvl17

162306: , AP_INVOICE_EXTRACT_DETAILS_V l1
162307: , AP_PO_HEADERS_EXTRACT_V l3
162308: , ZX_AP_DEF_TAX_EXTRACT_V l5
162309: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162310: , fnd_lookup_values fvl17
162311: , fnd_lookup_values fvl28
162312: , fnd_lookup_values fvl54
162313: , fnd_lookup_values fvl85
162314: , fnd_lookup_values fvl145

Line 162311: , fnd_lookup_values fvl28

162307: , AP_PO_HEADERS_EXTRACT_V l3
162308: , ZX_AP_DEF_TAX_EXTRACT_V l5
162309: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162310: , fnd_lookup_values fvl17
162311: , fnd_lookup_values fvl28
162312: , fnd_lookup_values fvl54
162313: , fnd_lookup_values fvl85
162314: , fnd_lookup_values fvl145
162315: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 162312: , fnd_lookup_values fvl54

162308: , ZX_AP_DEF_TAX_EXTRACT_V l5
162309: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162310: , fnd_lookup_values fvl17
162311: , fnd_lookup_values fvl28
162312: , fnd_lookup_values fvl54
162313: , fnd_lookup_values fvl85
162314: , fnd_lookup_values fvl145
162315: WHERE xet.event_id between x_first_event_id and x_last_event_id
162316: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 162313: , fnd_lookup_values fvl85

162309: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162310: , fnd_lookup_values fvl17
162311: , fnd_lookup_values fvl28
162312: , fnd_lookup_values fvl54
162313: , fnd_lookup_values fvl85
162314: , fnd_lookup_values fvl145
162315: WHERE xet.event_id between x_first_event_id and x_last_event_id
162316: and xet.event_date between p_pad_start_date and p_pad_end_date
162317: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 162314: , fnd_lookup_values fvl145

162310: , fnd_lookup_values fvl17
162311: , fnd_lookup_values fvl28
162312: , fnd_lookup_values fvl54
162313: , fnd_lookup_values fvl85
162314: , fnd_lookup_values fvl145
162315: WHERE xet.event_id between x_first_event_id and x_last_event_id
162316: and xet.event_date between p_pad_start_date and p_pad_end_date
162317: and xet.event_class_code = C_EVENT_CLASS_CODE
162318: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 164929: , fnd_lookup_values fvl10

164925: FROM xla_events_gt xet
164926: , AP_PAYMENT_EXTRACT_HEADER_V h2
164927: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
164928: , FV_XLA_PAYMENTS_V h5
164929: , fnd_lookup_values fvl10
164930: , fnd_lookup_values fvl14
164931: , fnd_lookup_values fvl20
164932: , fnd_lookup_values fvl43
164933: , fnd_lookup_values fvl116

Line 164930: , fnd_lookup_values fvl14

164926: , AP_PAYMENT_EXTRACT_HEADER_V h2
164927: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
164928: , FV_XLA_PAYMENTS_V h5
164929: , fnd_lookup_values fvl10
164930: , fnd_lookup_values fvl14
164931: , fnd_lookup_values fvl20
164932: , fnd_lookup_values fvl43
164933: , fnd_lookup_values fvl116
164934: , fnd_lookup_values fvl125

Line 164931: , fnd_lookup_values fvl20

164927: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
164928: , FV_XLA_PAYMENTS_V h5
164929: , fnd_lookup_values fvl10
164930: , fnd_lookup_values fvl14
164931: , fnd_lookup_values fvl20
164932: , fnd_lookup_values fvl43
164933: , fnd_lookup_values fvl116
164934: , fnd_lookup_values fvl125
164935: , fnd_lookup_values fvl177

Line 164932: , fnd_lookup_values fvl43

164928: , FV_XLA_PAYMENTS_V h5
164929: , fnd_lookup_values fvl10
164930: , fnd_lookup_values fvl14
164931: , fnd_lookup_values fvl20
164932: , fnd_lookup_values fvl43
164933: , fnd_lookup_values fvl116
164934: , fnd_lookup_values fvl125
164935: , fnd_lookup_values fvl177
164936: ,(select rownum r from all_objects where rownum <= 41 and owner = p_apps_owner)

Line 164933: , fnd_lookup_values fvl116

164929: , fnd_lookup_values fvl10
164930: , fnd_lookup_values fvl14
164931: , fnd_lookup_values fvl20
164932: , fnd_lookup_values fvl43
164933: , fnd_lookup_values fvl116
164934: , fnd_lookup_values fvl125
164935: , fnd_lookup_values fvl177
164936: ,(select rownum r from all_objects where rownum <= 41 and owner = p_apps_owner)
164937: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 164934: , fnd_lookup_values fvl125

164930: , fnd_lookup_values fvl14
164931: , fnd_lookup_values fvl20
164932: , fnd_lookup_values fvl43
164933: , fnd_lookup_values fvl116
164934: , fnd_lookup_values fvl125
164935: , fnd_lookup_values fvl177
164936: ,(select rownum r from all_objects where rownum <= 41 and owner = p_apps_owner)
164937: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
164938: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 164935: , fnd_lookup_values fvl177

164931: , fnd_lookup_values fvl20
164932: , fnd_lookup_values fvl43
164933: , fnd_lookup_values fvl116
164934: , fnd_lookup_values fvl125
164935: , fnd_lookup_values fvl177
164936: ,(select rownum r from all_objects where rownum <= 41 and owner = p_apps_owner)
164937: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
164938: AND xet.event_class_code = C_EVENT_CLASS_CODE
164939: AND h2.event_id = xet.event_id

Line 165280: , fnd_lookup_values fvl28

165276: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165277: , FV_XLA_AP_REF_V l4
165278: , ZX_AP_DEF_TAX_EXTRACT_V l6
165279: , ZX_AP_TAX_JRNL_LINE_DESC_V l7
165280: , fnd_lookup_values fvl28
165281: , fnd_lookup_values fvl54
165282: , fnd_lookup_values fvl56
165283: , fnd_lookup_values fvl85
165284: , fnd_lookup_values fvl101

Line 165281: , fnd_lookup_values fvl54

165277: , FV_XLA_AP_REF_V l4
165278: , ZX_AP_DEF_TAX_EXTRACT_V l6
165279: , ZX_AP_TAX_JRNL_LINE_DESC_V l7
165280: , fnd_lookup_values fvl28
165281: , fnd_lookup_values fvl54
165282: , fnd_lookup_values fvl56
165283: , fnd_lookup_values fvl85
165284: , fnd_lookup_values fvl101
165285: , fnd_lookup_values fvl140

Line 165282: , fnd_lookup_values fvl56

165278: , ZX_AP_DEF_TAX_EXTRACT_V l6
165279: , ZX_AP_TAX_JRNL_LINE_DESC_V l7
165280: , fnd_lookup_values fvl28
165281: , fnd_lookup_values fvl54
165282: , fnd_lookup_values fvl56
165283: , fnd_lookup_values fvl85
165284: , fnd_lookup_values fvl101
165285: , fnd_lookup_values fvl140
165286: , fnd_lookup_values fvl166

Line 165283: , fnd_lookup_values fvl85

165279: , ZX_AP_TAX_JRNL_LINE_DESC_V l7
165280: , fnd_lookup_values fvl28
165281: , fnd_lookup_values fvl54
165282: , fnd_lookup_values fvl56
165283: , fnd_lookup_values fvl85
165284: , fnd_lookup_values fvl101
165285: , fnd_lookup_values fvl140
165286: , fnd_lookup_values fvl166
165287: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)

Line 165284: , fnd_lookup_values fvl101

165280: , fnd_lookup_values fvl28
165281: , fnd_lookup_values fvl54
165282: , fnd_lookup_values fvl56
165283: , fnd_lookup_values fvl85
165284: , fnd_lookup_values fvl101
165285: , fnd_lookup_values fvl140
165286: , fnd_lookup_values fvl166
165287: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
165288: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 165285: , fnd_lookup_values fvl140

165281: , fnd_lookup_values fvl54
165282: , fnd_lookup_values fvl56
165283: , fnd_lookup_values fvl85
165284: , fnd_lookup_values fvl101
165285: , fnd_lookup_values fvl140
165286: , fnd_lookup_values fvl166
165287: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
165288: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165289: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 165286: , fnd_lookup_values fvl166

165282: , fnd_lookup_values fvl56
165283: , fnd_lookup_values fvl85
165284: , fnd_lookup_values fvl101
165285: , fnd_lookup_values fvl140
165286: , fnd_lookup_values fvl166
165287: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
165288: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165289: AND xet.event_class_code = C_EVENT_CLASS_CODE
165290: AND l1.event_id = xet.event_id

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

165446: l_balance_type_code VARCHAR2(1) :=NULL;
165447: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
165448:
165449: --
165450: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
165451: --
165452:
165453: TYPE t_array_source_3 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
165454: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 165718: , fnd_lookup_values fvl10

165714: FROM xla_events_gt xet
165715: , AP_PAYMENT_EXTRACT_HEADER_V h2
165716: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165717: , FV_XLA_PAYMENTS_V h5
165718: , fnd_lookup_values fvl10
165719: , fnd_lookup_values fvl14
165720: , fnd_lookup_values fvl20
165721: , fnd_lookup_values fvl43
165722: , fnd_lookup_values fvl116

Line 165719: , fnd_lookup_values fvl14

165715: , AP_PAYMENT_EXTRACT_HEADER_V h2
165716: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165717: , FV_XLA_PAYMENTS_V h5
165718: , fnd_lookup_values fvl10
165719: , fnd_lookup_values fvl14
165720: , fnd_lookup_values fvl20
165721: , fnd_lookup_values fvl43
165722: , fnd_lookup_values fvl116
165723: , fnd_lookup_values fvl125

Line 165720: , fnd_lookup_values fvl20

165716: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165717: , FV_XLA_PAYMENTS_V h5
165718: , fnd_lookup_values fvl10
165719: , fnd_lookup_values fvl14
165720: , fnd_lookup_values fvl20
165721: , fnd_lookup_values fvl43
165722: , fnd_lookup_values fvl116
165723: , fnd_lookup_values fvl125
165724: , fnd_lookup_values fvl177

Line 165721: , fnd_lookup_values fvl43

165717: , FV_XLA_PAYMENTS_V h5
165718: , fnd_lookup_values fvl10
165719: , fnd_lookup_values fvl14
165720: , fnd_lookup_values fvl20
165721: , fnd_lookup_values fvl43
165722: , fnd_lookup_values fvl116
165723: , fnd_lookup_values fvl125
165724: , fnd_lookup_values fvl177
165725: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 165722: , fnd_lookup_values fvl116

165718: , fnd_lookup_values fvl10
165719: , fnd_lookup_values fvl14
165720: , fnd_lookup_values fvl20
165721: , fnd_lookup_values fvl43
165722: , fnd_lookup_values fvl116
165723: , fnd_lookup_values fvl125
165724: , fnd_lookup_values fvl177
165725: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165726: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 165723: , fnd_lookup_values fvl125

165719: , fnd_lookup_values fvl14
165720: , fnd_lookup_values fvl20
165721: , fnd_lookup_values fvl43
165722: , fnd_lookup_values fvl116
165723: , fnd_lookup_values fvl125
165724: , fnd_lookup_values fvl177
165725: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165726: and xet.event_class_code = C_EVENT_CLASS_CODE
165727: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 165724: , fnd_lookup_values fvl177

165720: , fnd_lookup_values fvl20
165721: , fnd_lookup_values fvl43
165722: , fnd_lookup_values fvl116
165723: , fnd_lookup_values fvl125
165724: , fnd_lookup_values fvl177
165725: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165726: and xet.event_class_code = C_EVENT_CLASS_CODE
165727: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
165728: AND h3.asp_org_id = h2.ac_org_id AND h5.federal_org_id=h2.ac_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 165845: , fnd_lookup_values fvl28

165841: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165842: , FV_XLA_AP_REF_V l4
165843: , ZX_AP_DEF_TAX_EXTRACT_V l6
165844: , ZX_AP_TAX_JRNL_LINE_DESC_V l7
165845: , fnd_lookup_values fvl28
165846: , fnd_lookup_values fvl54
165847: , fnd_lookup_values fvl56
165848: , fnd_lookup_values fvl85
165849: , fnd_lookup_values fvl101

Line 165846: , fnd_lookup_values fvl54

165842: , FV_XLA_AP_REF_V l4
165843: , ZX_AP_DEF_TAX_EXTRACT_V l6
165844: , ZX_AP_TAX_JRNL_LINE_DESC_V l7
165845: , fnd_lookup_values fvl28
165846: , fnd_lookup_values fvl54
165847: , fnd_lookup_values fvl56
165848: , fnd_lookup_values fvl85
165849: , fnd_lookup_values fvl101
165850: , fnd_lookup_values fvl140

Line 165847: , fnd_lookup_values fvl56

165843: , ZX_AP_DEF_TAX_EXTRACT_V l6
165844: , ZX_AP_TAX_JRNL_LINE_DESC_V l7
165845: , fnd_lookup_values fvl28
165846: , fnd_lookup_values fvl54
165847: , fnd_lookup_values fvl56
165848: , fnd_lookup_values fvl85
165849: , fnd_lookup_values fvl101
165850: , fnd_lookup_values fvl140
165851: , fnd_lookup_values fvl166

Line 165848: , fnd_lookup_values fvl85

165844: , ZX_AP_TAX_JRNL_LINE_DESC_V l7
165845: , fnd_lookup_values fvl28
165846: , fnd_lookup_values fvl54
165847: , fnd_lookup_values fvl56
165848: , fnd_lookup_values fvl85
165849: , fnd_lookup_values fvl101
165850: , fnd_lookup_values fvl140
165851: , fnd_lookup_values fvl166
165852: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 165849: , fnd_lookup_values fvl101

165845: , fnd_lookup_values fvl28
165846: , fnd_lookup_values fvl54
165847: , fnd_lookup_values fvl56
165848: , fnd_lookup_values fvl85
165849: , fnd_lookup_values fvl101
165850: , fnd_lookup_values fvl140
165851: , fnd_lookup_values fvl166
165852: WHERE xet.event_id between x_first_event_id and x_last_event_id
165853: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 165850: , fnd_lookup_values fvl140

165846: , fnd_lookup_values fvl54
165847: , fnd_lookup_values fvl56
165848: , fnd_lookup_values fvl85
165849: , fnd_lookup_values fvl101
165850: , fnd_lookup_values fvl140
165851: , fnd_lookup_values fvl166
165852: WHERE xet.event_id between x_first_event_id and x_last_event_id
165853: and xet.event_date between p_pad_start_date and p_pad_end_date
165854: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 165851: , fnd_lookup_values fvl166

165847: , fnd_lookup_values fvl56
165848: , fnd_lookup_values fvl85
165849: , fnd_lookup_values fvl101
165850: , fnd_lookup_values fvl140
165851: , fnd_lookup_values fvl166
165852: WHERE xet.event_id between x_first_event_id and x_last_event_id
165853: and xet.event_date between p_pad_start_date and p_pad_end_date
165854: and xet.event_class_code = C_EVENT_CLASS_CODE
165855: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 168591: , fnd_lookup_values fvl10

168587: END source_meaning
168588: FROM xla_events_gt xet
168589: , AP_INVOICE_EXTRACT_HEADER_V h1
168590: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
168591: , fnd_lookup_values fvl10
168592: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
168593: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168594: AND xet.event_class_code = C_EVENT_CLASS_CODE
168595: AND h1.event_id = xet.event_id

Line 168938: , fnd_lookup_values fvl85

168934: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
168935: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
168936: , ZX_AP_DEF_TAX_EXTRACT_V l5
168937: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
168938: , fnd_lookup_values fvl85
168939: , fnd_lookup_values fvl129
168940: , fnd_lookup_values fvl140
168941: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
168942: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 168939: , fnd_lookup_values fvl129

168935: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
168936: , ZX_AP_DEF_TAX_EXTRACT_V l5
168937: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
168938: , fnd_lookup_values fvl85
168939: , fnd_lookup_values fvl129
168940: , fnd_lookup_values fvl140
168941: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
168942: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168943: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 168940: , fnd_lookup_values fvl140

168936: , ZX_AP_DEF_TAX_EXTRACT_V l5
168937: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
168938: , fnd_lookup_values fvl85
168939: , fnd_lookup_values fvl129
168940: , fnd_lookup_values fvl140
168941: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
168942: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168943: AND xet.event_class_code = C_EVENT_CLASS_CODE
168944: AND l2.event_id = xet.event_id

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

169083: l_balance_type_code VARCHAR2(1) :=NULL;
169084: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
169085:
169086: --
169087: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
169088: --
169089:
169090: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
169091: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 169275: , fnd_lookup_values fvl10

169271: , h1.INV_DOC_SEQUENCE_VALUE source_173
169272: FROM xla_events_gt xet
169273: , AP_INVOICE_EXTRACT_HEADER_V h1
169274: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
169275: , fnd_lookup_values fvl10
169276: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
169277: and xet.event_class_code = C_EVENT_CLASS_CODE
169278: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
169279: AND h4.asp_org_id = h1.ai_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 169374: , fnd_lookup_values fvl85

169370: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
169371: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
169372: , ZX_AP_DEF_TAX_EXTRACT_V l5
169373: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
169374: , fnd_lookup_values fvl85
169375: , fnd_lookup_values fvl129
169376: , fnd_lookup_values fvl140
169377: WHERE xet.event_id between x_first_event_id and x_last_event_id
169378: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 169375: , fnd_lookup_values fvl129

169371: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
169372: , ZX_AP_DEF_TAX_EXTRACT_V l5
169373: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
169374: , fnd_lookup_values fvl85
169375: , fnd_lookup_values fvl129
169376: , fnd_lookup_values fvl140
169377: WHERE xet.event_id between x_first_event_id and x_last_event_id
169378: and xet.event_date between p_pad_start_date and p_pad_end_date
169379: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 169376: , fnd_lookup_values fvl140

169372: , ZX_AP_DEF_TAX_EXTRACT_V l5
169373: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
169374: , fnd_lookup_values fvl85
169375: , fnd_lookup_values fvl129
169376: , fnd_lookup_values fvl140
169377: WHERE xet.event_id between x_first_event_id and x_last_event_id
169378: and xet.event_date between p_pad_start_date and p_pad_end_date
169379: and xet.event_class_code = C_EVENT_CLASS_CODE
169380: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 170965: , fnd_lookup_values fvl10

170961: END source_meaning
170962: FROM xla_events_gt xet
170963: , AP_INVOICE_EXTRACT_HEADER_V h2
170964: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
170965: , fnd_lookup_values fvl10
170966: , fnd_lookup_values fvl26
170967: , fnd_lookup_values fvl43
170968: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
170969: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 170966: , fnd_lookup_values fvl26

170962: FROM xla_events_gt xet
170963: , AP_INVOICE_EXTRACT_HEADER_V h2
170964: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
170965: , fnd_lookup_values fvl10
170966: , fnd_lookup_values fvl26
170967: , fnd_lookup_values fvl43
170968: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
170969: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
170970: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 170967: , fnd_lookup_values fvl43

170963: , AP_INVOICE_EXTRACT_HEADER_V h2
170964: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
170965: , fnd_lookup_values fvl10
170966: , fnd_lookup_values fvl26
170967: , fnd_lookup_values fvl43
170968: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
170969: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
170970: AND xet.event_class_code = C_EVENT_CLASS_CODE
170971: AND h2.event_id = xet.event_id

Line 171305: , fnd_lookup_values fvl17

171301: , AP_INVOICE_EXTRACT_DETAILS_V l1
171302: , AP_PO_HEADERS_EXTRACT_V l3
171303: , ZX_AP_DEF_TAX_EXTRACT_V l5
171304: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
171305: , fnd_lookup_values fvl17
171306: , fnd_lookup_values fvl28
171307: , fnd_lookup_values fvl54
171308: , fnd_lookup_values fvl85
171309: , fnd_lookup_values fvl140

Line 171306: , fnd_lookup_values fvl28

171302: , AP_PO_HEADERS_EXTRACT_V l3
171303: , ZX_AP_DEF_TAX_EXTRACT_V l5
171304: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
171305: , fnd_lookup_values fvl17
171306: , fnd_lookup_values fvl28
171307: , fnd_lookup_values fvl54
171308: , fnd_lookup_values fvl85
171309: , fnd_lookup_values fvl140
171310: , fnd_lookup_values fvl145

Line 171307: , fnd_lookup_values fvl54

171303: , ZX_AP_DEF_TAX_EXTRACT_V l5
171304: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
171305: , fnd_lookup_values fvl17
171306: , fnd_lookup_values fvl28
171307: , fnd_lookup_values fvl54
171308: , fnd_lookup_values fvl85
171309: , fnd_lookup_values fvl140
171310: , fnd_lookup_values fvl145
171311: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)

Line 171308: , fnd_lookup_values fvl85

171304: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
171305: , fnd_lookup_values fvl17
171306: , fnd_lookup_values fvl28
171307: , fnd_lookup_values fvl54
171308: , fnd_lookup_values fvl85
171309: , fnd_lookup_values fvl140
171310: , fnd_lookup_values fvl145
171311: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)
171312: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 171309: , fnd_lookup_values fvl140

171305: , fnd_lookup_values fvl17
171306: , fnd_lookup_values fvl28
171307: , fnd_lookup_values fvl54
171308: , fnd_lookup_values fvl85
171309: , fnd_lookup_values fvl140
171310: , fnd_lookup_values fvl145
171311: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)
171312: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171313: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 171310: , fnd_lookup_values fvl145

171306: , fnd_lookup_values fvl28
171307: , fnd_lookup_values fvl54
171308: , fnd_lookup_values fvl85
171309: , fnd_lookup_values fvl140
171310: , fnd_lookup_values fvl145
171311: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)
171312: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171313: AND xet.event_class_code = C_EVENT_CLASS_CODE
171314: AND l1.event_id = xet.event_id

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

171465: l_balance_type_code VARCHAR2(1) :=NULL;
171466: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
171467:
171468: --
171469: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
171470: --
171471:
171472: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
171473: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 171659: , fnd_lookup_values fvl10

171655: , h2.INV_DOC_SEQUENCE_VALUE source_173
171656: FROM xla_events_gt xet
171657: , AP_INVOICE_EXTRACT_HEADER_V h2
171658: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
171659: , fnd_lookup_values fvl10
171660: , fnd_lookup_values fvl26
171661: , fnd_lookup_values fvl43
171662: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
171663: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 171660: , fnd_lookup_values fvl26

171656: FROM xla_events_gt xet
171657: , AP_INVOICE_EXTRACT_HEADER_V h2
171658: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
171659: , fnd_lookup_values fvl10
171660: , fnd_lookup_values fvl26
171661: , fnd_lookup_values fvl43
171662: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
171663: and xet.event_class_code = C_EVENT_CLASS_CODE
171664: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 171661: , fnd_lookup_values fvl43

171657: , AP_INVOICE_EXTRACT_HEADER_V h2
171658: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
171659: , fnd_lookup_values fvl10
171660: , fnd_lookup_values fvl26
171661: , fnd_lookup_values fvl43
171662: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
171663: and xet.event_class_code = C_EVENT_CLASS_CODE
171664: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
171665: AND h4.asp_org_id = h2.ai_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 171767: , fnd_lookup_values fvl17

171763: , AP_INVOICE_EXTRACT_DETAILS_V l1
171764: , AP_PO_HEADERS_EXTRACT_V l3
171765: , ZX_AP_DEF_TAX_EXTRACT_V l5
171766: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
171767: , fnd_lookup_values fvl17
171768: , fnd_lookup_values fvl28
171769: , fnd_lookup_values fvl54
171770: , fnd_lookup_values fvl85
171771: , fnd_lookup_values fvl140

Line 171768: , fnd_lookup_values fvl28

171764: , AP_PO_HEADERS_EXTRACT_V l3
171765: , ZX_AP_DEF_TAX_EXTRACT_V l5
171766: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
171767: , fnd_lookup_values fvl17
171768: , fnd_lookup_values fvl28
171769: , fnd_lookup_values fvl54
171770: , fnd_lookup_values fvl85
171771: , fnd_lookup_values fvl140
171772: , fnd_lookup_values fvl145

Line 171769: , fnd_lookup_values fvl54

171765: , ZX_AP_DEF_TAX_EXTRACT_V l5
171766: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
171767: , fnd_lookup_values fvl17
171768: , fnd_lookup_values fvl28
171769: , fnd_lookup_values fvl54
171770: , fnd_lookup_values fvl85
171771: , fnd_lookup_values fvl140
171772: , fnd_lookup_values fvl145
171773: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 171770: , fnd_lookup_values fvl85

171766: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
171767: , fnd_lookup_values fvl17
171768: , fnd_lookup_values fvl28
171769: , fnd_lookup_values fvl54
171770: , fnd_lookup_values fvl85
171771: , fnd_lookup_values fvl140
171772: , fnd_lookup_values fvl145
171773: WHERE xet.event_id between x_first_event_id and x_last_event_id
171774: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 171771: , fnd_lookup_values fvl140

171767: , fnd_lookup_values fvl17
171768: , fnd_lookup_values fvl28
171769: , fnd_lookup_values fvl54
171770: , fnd_lookup_values fvl85
171771: , fnd_lookup_values fvl140
171772: , fnd_lookup_values fvl145
171773: WHERE xet.event_id between x_first_event_id and x_last_event_id
171774: and xet.event_date between p_pad_start_date and p_pad_end_date
171775: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 171772: , fnd_lookup_values fvl145

171768: , fnd_lookup_values fvl28
171769: , fnd_lookup_values fvl54
171770: , fnd_lookup_values fvl85
171771: , fnd_lookup_values fvl140
171772: , fnd_lookup_values fvl145
171773: WHERE xet.event_id between x_first_event_id and x_last_event_id
171774: and xet.event_date between p_pad_start_date and p_pad_end_date
171775: and xet.event_class_code = C_EVENT_CLASS_CODE
171776: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 174274: , fnd_lookup_values fvl10

174270: END source_meaning
174271: FROM xla_events_gt xet
174272: , AP_PAYMENT_EXTRACT_HEADER_V h2
174273: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
174274: , fnd_lookup_values fvl10
174275: , fnd_lookup_values fvl14
174276: , fnd_lookup_values fvl43
174277: , fnd_lookup_values fvl116
174278: , fnd_lookup_values fvl125

Line 174275: , fnd_lookup_values fvl14

174271: FROM xla_events_gt xet
174272: , AP_PAYMENT_EXTRACT_HEADER_V h2
174273: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
174274: , fnd_lookup_values fvl10
174275: , fnd_lookup_values fvl14
174276: , fnd_lookup_values fvl43
174277: , fnd_lookup_values fvl116
174278: , fnd_lookup_values fvl125
174279: ,(select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)

Line 174276: , fnd_lookup_values fvl43

174272: , AP_PAYMENT_EXTRACT_HEADER_V h2
174273: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
174274: , fnd_lookup_values fvl10
174275: , fnd_lookup_values fvl14
174276: , fnd_lookup_values fvl43
174277: , fnd_lookup_values fvl116
174278: , fnd_lookup_values fvl125
174279: ,(select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)
174280: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 174277: , fnd_lookup_values fvl116

174273: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
174274: , fnd_lookup_values fvl10
174275: , fnd_lookup_values fvl14
174276: , fnd_lookup_values fvl43
174277: , fnd_lookup_values fvl116
174278: , fnd_lookup_values fvl125
174279: ,(select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)
174280: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174281: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 174278: , fnd_lookup_values fvl125

174274: , fnd_lookup_values fvl10
174275: , fnd_lookup_values fvl14
174276: , fnd_lookup_values fvl43
174277: , fnd_lookup_values fvl116
174278: , fnd_lookup_values fvl125
174279: ,(select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)
174280: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174281: AND xet.event_class_code = C_EVENT_CLASS_CODE
174282: AND h2.event_id = xet.event_id

Line 174612: , fnd_lookup_values fvl28

174608: END source_meaning
174609: FROM xla_events_gt xet
174610: , AP_PAYMENT_EXTRACT_DETAILS_V l1
174611: , ZX_AP_DEF_TAX_EXTRACT_V l4
174612: , fnd_lookup_values fvl28
174613: , fnd_lookup_values fvl56
174614: , fnd_lookup_values fvl85
174615: , fnd_lookup_values fvl101
174616: , fnd_lookup_values fvl140

Line 174613: , fnd_lookup_values fvl56

174609: FROM xla_events_gt xet
174610: , AP_PAYMENT_EXTRACT_DETAILS_V l1
174611: , ZX_AP_DEF_TAX_EXTRACT_V l4
174612: , fnd_lookup_values fvl28
174613: , fnd_lookup_values fvl56
174614: , fnd_lookup_values fvl85
174615: , fnd_lookup_values fvl101
174616: , fnd_lookup_values fvl140
174617: , fnd_lookup_values fvl166

Line 174614: , fnd_lookup_values fvl85

174610: , AP_PAYMENT_EXTRACT_DETAILS_V l1
174611: , ZX_AP_DEF_TAX_EXTRACT_V l4
174612: , fnd_lookup_values fvl28
174613: , fnd_lookup_values fvl56
174614: , fnd_lookup_values fvl85
174615: , fnd_lookup_values fvl101
174616: , fnd_lookup_values fvl140
174617: , fnd_lookup_values fvl166
174618: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)

Line 174615: , fnd_lookup_values fvl101

174611: , ZX_AP_DEF_TAX_EXTRACT_V l4
174612: , fnd_lookup_values fvl28
174613: , fnd_lookup_values fvl56
174614: , fnd_lookup_values fvl85
174615: , fnd_lookup_values fvl101
174616: , fnd_lookup_values fvl140
174617: , fnd_lookup_values fvl166
174618: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
174619: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 174616: , fnd_lookup_values fvl140

174612: , fnd_lookup_values fvl28
174613: , fnd_lookup_values fvl56
174614: , fnd_lookup_values fvl85
174615: , fnd_lookup_values fvl101
174616: , fnd_lookup_values fvl140
174617: , fnd_lookup_values fvl166
174618: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
174619: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174620: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 174617: , fnd_lookup_values fvl166

174613: , fnd_lookup_values fvl56
174614: , fnd_lookup_values fvl85
174615: , fnd_lookup_values fvl101
174616: , fnd_lookup_values fvl140
174617: , fnd_lookup_values fvl166
174618: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
174619: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174620: AND xet.event_class_code = C_EVENT_CLASS_CODE
174621: AND l1.event_id = xet.event_id

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

174772: l_balance_type_code VARCHAR2(1) :=NULL;
174773: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
174774:
174775: --
174776: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
174777: --
174778:
174779: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
174780: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 175014: , fnd_lookup_values fvl10

175010: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_176
175011: FROM xla_events_gt xet
175012: , AP_PAYMENT_EXTRACT_HEADER_V h2
175013: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
175014: , fnd_lookup_values fvl10
175015: , fnd_lookup_values fvl14
175016: , fnd_lookup_values fvl43
175017: , fnd_lookup_values fvl116
175018: , fnd_lookup_values fvl125

Line 175015: , fnd_lookup_values fvl14

175011: FROM xla_events_gt xet
175012: , AP_PAYMENT_EXTRACT_HEADER_V h2
175013: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
175014: , fnd_lookup_values fvl10
175015: , fnd_lookup_values fvl14
175016: , fnd_lookup_values fvl43
175017: , fnd_lookup_values fvl116
175018: , fnd_lookup_values fvl125
175019: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 175016: , fnd_lookup_values fvl43

175012: , AP_PAYMENT_EXTRACT_HEADER_V h2
175013: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
175014: , fnd_lookup_values fvl10
175015: , fnd_lookup_values fvl14
175016: , fnd_lookup_values fvl43
175017: , fnd_lookup_values fvl116
175018: , fnd_lookup_values fvl125
175019: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
175020: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 175017: , fnd_lookup_values fvl116

175013: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
175014: , fnd_lookup_values fvl10
175015: , fnd_lookup_values fvl14
175016: , fnd_lookup_values fvl43
175017: , fnd_lookup_values fvl116
175018: , fnd_lookup_values fvl125
175019: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
175020: and xet.event_class_code = C_EVENT_CLASS_CODE
175021: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 175018: , fnd_lookup_values fvl125

175014: , fnd_lookup_values fvl10
175015: , fnd_lookup_values fvl14
175016: , fnd_lookup_values fvl43
175017: , fnd_lookup_values fvl116
175018: , fnd_lookup_values fvl125
175019: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
175020: and xet.event_class_code = C_EVENT_CLASS_CODE
175021: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
175022: AND h3.asp_org_id = h2.ac_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 175128: , fnd_lookup_values fvl28

175124: , fvl166.meaning source_166_meaning
175125: FROM xla_events_gt xet
175126: , AP_PAYMENT_EXTRACT_DETAILS_V l1
175127: , ZX_AP_DEF_TAX_EXTRACT_V l4
175128: , fnd_lookup_values fvl28
175129: , fnd_lookup_values fvl56
175130: , fnd_lookup_values fvl85
175131: , fnd_lookup_values fvl101
175132: , fnd_lookup_values fvl140

Line 175129: , fnd_lookup_values fvl56

175125: FROM xla_events_gt xet
175126: , AP_PAYMENT_EXTRACT_DETAILS_V l1
175127: , ZX_AP_DEF_TAX_EXTRACT_V l4
175128: , fnd_lookup_values fvl28
175129: , fnd_lookup_values fvl56
175130: , fnd_lookup_values fvl85
175131: , fnd_lookup_values fvl101
175132: , fnd_lookup_values fvl140
175133: , fnd_lookup_values fvl166

Line 175130: , fnd_lookup_values fvl85

175126: , AP_PAYMENT_EXTRACT_DETAILS_V l1
175127: , ZX_AP_DEF_TAX_EXTRACT_V l4
175128: , fnd_lookup_values fvl28
175129: , fnd_lookup_values fvl56
175130: , fnd_lookup_values fvl85
175131: , fnd_lookup_values fvl101
175132: , fnd_lookup_values fvl140
175133: , fnd_lookup_values fvl166
175134: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 175131: , fnd_lookup_values fvl101

175127: , ZX_AP_DEF_TAX_EXTRACT_V l4
175128: , fnd_lookup_values fvl28
175129: , fnd_lookup_values fvl56
175130: , fnd_lookup_values fvl85
175131: , fnd_lookup_values fvl101
175132: , fnd_lookup_values fvl140
175133: , fnd_lookup_values fvl166
175134: WHERE xet.event_id between x_first_event_id and x_last_event_id
175135: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 175132: , fnd_lookup_values fvl140

175128: , fnd_lookup_values fvl28
175129: , fnd_lookup_values fvl56
175130: , fnd_lookup_values fvl85
175131: , fnd_lookup_values fvl101
175132: , fnd_lookup_values fvl140
175133: , fnd_lookup_values fvl166
175134: WHERE xet.event_id between x_first_event_id and x_last_event_id
175135: and xet.event_date between p_pad_start_date and p_pad_end_date
175136: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 175133: , fnd_lookup_values fvl166

175129: , fnd_lookup_values fvl56
175130: , fnd_lookup_values fvl85
175131: , fnd_lookup_values fvl101
175132: , fnd_lookup_values fvl140
175133: , fnd_lookup_values fvl166
175134: WHERE xet.event_id between x_first_event_id and x_last_event_id
175135: and xet.event_date between p_pad_start_date and p_pad_end_date
175136: and xet.event_class_code = C_EVENT_CLASS_CODE
175137: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 177335: , fnd_lookup_values fvl10

177331: END source_meaning
177332: FROM xla_events_gt xet
177333: , AP_PAYMENT_EXTRACT_HEADER_V h2
177334: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177335: , fnd_lookup_values fvl10
177336: , fnd_lookup_values fvl14
177337: , fnd_lookup_values fvl43
177338: , fnd_lookup_values fvl116
177339: , fnd_lookup_values fvl125

Line 177336: , fnd_lookup_values fvl14

177332: FROM xla_events_gt xet
177333: , AP_PAYMENT_EXTRACT_HEADER_V h2
177334: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177335: , fnd_lookup_values fvl10
177336: , fnd_lookup_values fvl14
177337: , fnd_lookup_values fvl43
177338: , fnd_lookup_values fvl116
177339: , fnd_lookup_values fvl125
177340: , fnd_lookup_values fvl177

Line 177337: , fnd_lookup_values fvl43

177333: , AP_PAYMENT_EXTRACT_HEADER_V h2
177334: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177335: , fnd_lookup_values fvl10
177336: , fnd_lookup_values fvl14
177337: , fnd_lookup_values fvl43
177338: , fnd_lookup_values fvl116
177339: , fnd_lookup_values fvl125
177340: , fnd_lookup_values fvl177
177341: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)

Line 177338: , fnd_lookup_values fvl116

177334: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177335: , fnd_lookup_values fvl10
177336: , fnd_lookup_values fvl14
177337: , fnd_lookup_values fvl43
177338: , fnd_lookup_values fvl116
177339: , fnd_lookup_values fvl125
177340: , fnd_lookup_values fvl177
177341: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
177342: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 177339: , fnd_lookup_values fvl125

177335: , fnd_lookup_values fvl10
177336: , fnd_lookup_values fvl14
177337: , fnd_lookup_values fvl43
177338: , fnd_lookup_values fvl116
177339: , fnd_lookup_values fvl125
177340: , fnd_lookup_values fvl177
177341: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
177342: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177343: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 177340: , fnd_lookup_values fvl177

177336: , fnd_lookup_values fvl14
177337: , fnd_lookup_values fvl43
177338: , fnd_lookup_values fvl116
177339: , fnd_lookup_values fvl125
177340: , fnd_lookup_values fvl177
177341: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
177342: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177343: AND xet.event_class_code = C_EVENT_CLASS_CODE
177344: AND h2.event_id = xet.event_id

Line 177601: , fnd_lookup_values fvl28

177597: FROM xla_events_gt xet
177598: , AP_PAYMENT_EXTRACT_DETAILS_V l1
177599: , ZX_AP_DEF_TAX_EXTRACT_V l4
177600: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
177601: , fnd_lookup_values fvl28
177602: , fnd_lookup_values fvl85
177603: , fnd_lookup_values fvl101
177604: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
177605: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 177602: , fnd_lookup_values fvl85

177598: , AP_PAYMENT_EXTRACT_DETAILS_V l1
177599: , ZX_AP_DEF_TAX_EXTRACT_V l4
177600: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
177601: , fnd_lookup_values fvl28
177602: , fnd_lookup_values fvl85
177603: , fnd_lookup_values fvl101
177604: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
177605: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177606: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 177603: , fnd_lookup_values fvl101

177599: , ZX_AP_DEF_TAX_EXTRACT_V l4
177600: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
177601: , fnd_lookup_values fvl28
177602: , fnd_lookup_values fvl85
177603: , fnd_lookup_values fvl101
177604: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
177605: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177606: AND xet.event_class_code = C_EVENT_CLASS_CODE
177607: AND l1.event_id = xet.event_id

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

177746: l_balance_type_code VARCHAR2(1) :=NULL;
177747: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
177748:
177749: --
177750: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
177751: --
177752:
177753: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
177754: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 177939: , fnd_lookup_values fvl10

177935: , fvl177.meaning source_177_meaning
177936: FROM xla_events_gt xet
177937: , AP_PAYMENT_EXTRACT_HEADER_V h2
177938: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177939: , fnd_lookup_values fvl10
177940: , fnd_lookup_values fvl14
177941: , fnd_lookup_values fvl43
177942: , fnd_lookup_values fvl116
177943: , fnd_lookup_values fvl125

Line 177940: , fnd_lookup_values fvl14

177936: FROM xla_events_gt xet
177937: , AP_PAYMENT_EXTRACT_HEADER_V h2
177938: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177939: , fnd_lookup_values fvl10
177940: , fnd_lookup_values fvl14
177941: , fnd_lookup_values fvl43
177942: , fnd_lookup_values fvl116
177943: , fnd_lookup_values fvl125
177944: , fnd_lookup_values fvl177

Line 177941: , fnd_lookup_values fvl43

177937: , AP_PAYMENT_EXTRACT_HEADER_V h2
177938: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177939: , fnd_lookup_values fvl10
177940: , fnd_lookup_values fvl14
177941: , fnd_lookup_values fvl43
177942: , fnd_lookup_values fvl116
177943: , fnd_lookup_values fvl125
177944: , fnd_lookup_values fvl177
177945: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 177942: , fnd_lookup_values fvl116

177938: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177939: , fnd_lookup_values fvl10
177940: , fnd_lookup_values fvl14
177941: , fnd_lookup_values fvl43
177942: , fnd_lookup_values fvl116
177943: , fnd_lookup_values fvl125
177944: , fnd_lookup_values fvl177
177945: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
177946: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 177943: , fnd_lookup_values fvl125

177939: , fnd_lookup_values fvl10
177940: , fnd_lookup_values fvl14
177941: , fnd_lookup_values fvl43
177942: , fnd_lookup_values fvl116
177943: , fnd_lookup_values fvl125
177944: , fnd_lookup_values fvl177
177945: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
177946: and xet.event_class_code = C_EVENT_CLASS_CODE
177947: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 177944: , fnd_lookup_values fvl177

177940: , fnd_lookup_values fvl14
177941: , fnd_lookup_values fvl43
177942: , fnd_lookup_values fvl116
177943: , fnd_lookup_values fvl125
177944: , fnd_lookup_values fvl177
177945: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
177946: and xet.event_class_code = C_EVENT_CLASS_CODE
177947: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
177948: AND h3.asp_org_id = h2.ac_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 178041: , fnd_lookup_values fvl28

178037: FROM xla_events_gt xet
178038: , AP_PAYMENT_EXTRACT_DETAILS_V l1
178039: , ZX_AP_DEF_TAX_EXTRACT_V l4
178040: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
178041: , fnd_lookup_values fvl28
178042: , fnd_lookup_values fvl85
178043: , fnd_lookup_values fvl101
178044: WHERE xet.event_id between x_first_event_id and x_last_event_id
178045: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 178042: , fnd_lookup_values fvl85

178038: , AP_PAYMENT_EXTRACT_DETAILS_V l1
178039: , ZX_AP_DEF_TAX_EXTRACT_V l4
178040: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
178041: , fnd_lookup_values fvl28
178042: , fnd_lookup_values fvl85
178043: , fnd_lookup_values fvl101
178044: WHERE xet.event_id between x_first_event_id and x_last_event_id
178045: and xet.event_date between p_pad_start_date and p_pad_end_date
178046: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 178043: , fnd_lookup_values fvl101

178039: , ZX_AP_DEF_TAX_EXTRACT_V l4
178040: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
178041: , fnd_lookup_values fvl28
178042: , fnd_lookup_values fvl85
178043: , fnd_lookup_values fvl101
178044: WHERE xet.event_id between x_first_event_id and x_last_event_id
178045: and xet.event_date between p_pad_start_date and p_pad_end_date
178046: and xet.event_class_code = C_EVENT_CLASS_CODE
178047: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id