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

Line 144116: , fnd_lookup_values fvl15

144112: END source_meaning
144113: FROM xla_events_gt xet
144114: , AP_INVOICE_EXTRACT_HEADER_V h2
144115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144116: , fnd_lookup_values fvl15
144117: , fnd_lookup_values fvl47
144118: , fnd_lookup_values fvl165
144119: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
144120: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 144117: , fnd_lookup_values fvl47

144113: FROM xla_events_gt xet
144114: , AP_INVOICE_EXTRACT_HEADER_V h2
144115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144116: , fnd_lookup_values fvl15
144117: , fnd_lookup_values fvl47
144118: , fnd_lookup_values fvl165
144119: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
144120: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144121: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 144118: , fnd_lookup_values fvl165

144114: , AP_INVOICE_EXTRACT_HEADER_V h2
144115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144116: , fnd_lookup_values fvl15
144117: , fnd_lookup_values fvl47
144118: , fnd_lookup_values fvl165
144119: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
144120: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144121: AND xet.event_class_code = C_EVENT_CLASS_CODE
144122: AND h2.event_id = xet.event_id

Line 144470: , fnd_lookup_values fvl22

144466: , AP_INVOICE_EXTRACT_DETAILS_V l1
144467: , AP_PO_HEADERS_EXTRACT_V l3
144468: , ZX_AP_DEF_TAX_EXTRACT_V l5
144469: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144470: , fnd_lookup_values fvl22
144471: , fnd_lookup_values fvl33
144472: , fnd_lookup_values fvl80
144473: , fnd_lookup_values fvl96
144474: , fnd_lookup_values fvl142

Line 144471: , fnd_lookup_values fvl33

144467: , AP_PO_HEADERS_EXTRACT_V l3
144468: , ZX_AP_DEF_TAX_EXTRACT_V l5
144469: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144470: , fnd_lookup_values fvl22
144471: , fnd_lookup_values fvl33
144472: , fnd_lookup_values fvl80
144473: , fnd_lookup_values fvl96
144474: , fnd_lookup_values fvl142
144475: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)

Line 144472: , fnd_lookup_values fvl80

144468: , ZX_AP_DEF_TAX_EXTRACT_V l5
144469: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144470: , fnd_lookup_values fvl22
144471: , fnd_lookup_values fvl33
144472: , fnd_lookup_values fvl80
144473: , fnd_lookup_values fvl96
144474: , fnd_lookup_values fvl142
144475: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
144476: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 144473: , fnd_lookup_values fvl96

144469: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144470: , fnd_lookup_values fvl22
144471: , fnd_lookup_values fvl33
144472: , fnd_lookup_values fvl80
144473: , fnd_lookup_values fvl96
144474: , fnd_lookup_values fvl142
144475: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
144476: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144477: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 144474: , fnd_lookup_values fvl142

144470: , fnd_lookup_values fvl22
144471: , fnd_lookup_values fvl33
144472: , fnd_lookup_values fvl80
144473: , fnd_lookup_values fvl96
144474: , fnd_lookup_values fvl142
144475: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
144476: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144477: AND xet.event_class_code = C_EVENT_CLASS_CODE
144478: AND l1.event_id = xet.event_id

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

144625: l_balance_type_code VARCHAR2(1) :=NULL;
144626: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
144627:
144628: --
144629: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
144630: --
144631:
144632: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144633: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 144839: , fnd_lookup_values fvl15

144835: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
144836: FROM xla_events_gt xet
144837: , AP_INVOICE_EXTRACT_HEADER_V h2
144838: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144839: , fnd_lookup_values fvl15
144840: , fnd_lookup_values fvl47
144841: , fnd_lookup_values fvl165
144842: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
144843: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 144840: , fnd_lookup_values fvl47

144836: FROM xla_events_gt xet
144837: , AP_INVOICE_EXTRACT_HEADER_V h2
144838: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144839: , fnd_lookup_values fvl15
144840: , fnd_lookup_values fvl47
144841: , fnd_lookup_values fvl165
144842: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
144843: and xet.event_class_code = C_EVENT_CLASS_CODE
144844: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 144841: , fnd_lookup_values fvl165

144837: , AP_INVOICE_EXTRACT_HEADER_V h2
144838: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144839: , fnd_lookup_values fvl15
144840: , fnd_lookup_values fvl47
144841: , fnd_lookup_values fvl165
144842: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
144843: and xet.event_class_code = C_EVENT_CLASS_CODE
144844: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
144845: AND h4.asp_org_id = h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 144949: , fnd_lookup_values fvl22

144945: , AP_INVOICE_EXTRACT_DETAILS_V l1
144946: , AP_PO_HEADERS_EXTRACT_V l3
144947: , ZX_AP_DEF_TAX_EXTRACT_V l5
144948: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144949: , fnd_lookup_values fvl22
144950: , fnd_lookup_values fvl33
144951: , fnd_lookup_values fvl80
144952: , fnd_lookup_values fvl96
144953: , fnd_lookup_values fvl142

Line 144950: , fnd_lookup_values fvl33

144946: , AP_PO_HEADERS_EXTRACT_V l3
144947: , ZX_AP_DEF_TAX_EXTRACT_V l5
144948: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144949: , fnd_lookup_values fvl22
144950: , fnd_lookup_values fvl33
144951: , fnd_lookup_values fvl80
144952: , fnd_lookup_values fvl96
144953: , fnd_lookup_values fvl142
144954: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 144951: , fnd_lookup_values fvl80

144947: , ZX_AP_DEF_TAX_EXTRACT_V l5
144948: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144949: , fnd_lookup_values fvl22
144950: , fnd_lookup_values fvl33
144951: , fnd_lookup_values fvl80
144952: , fnd_lookup_values fvl96
144953: , fnd_lookup_values fvl142
144954: WHERE xet.event_id between x_first_event_id and x_last_event_id
144955: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 144952: , fnd_lookup_values fvl96

144948: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144949: , fnd_lookup_values fvl22
144950: , fnd_lookup_values fvl33
144951: , fnd_lookup_values fvl80
144952: , fnd_lookup_values fvl96
144953: , fnd_lookup_values fvl142
144954: WHERE xet.event_id between x_first_event_id and x_last_event_id
144955: and xet.event_date between p_pad_start_date and p_pad_end_date
144956: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 144953: , fnd_lookup_values fvl142

144949: , fnd_lookup_values fvl22
144950: , fnd_lookup_values fvl33
144951: , fnd_lookup_values fvl80
144952: , fnd_lookup_values fvl96
144953: , fnd_lookup_values fvl142
144954: WHERE xet.event_id between x_first_event_id and x_last_event_id
144955: and xet.event_date between p_pad_start_date and p_pad_end_date
144956: and xet.event_class_code = C_EVENT_CLASS_CODE
144957: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 147410: , fnd_lookup_values fvl15

147406: END source_meaning
147407: FROM xla_events_gt xet
147408: , AP_INVOICE_EXTRACT_HEADER_V h2
147409: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
147410: , fnd_lookup_values fvl15
147411: , fnd_lookup_values fvl47
147412: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
147413: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147414: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 147411: , fnd_lookup_values fvl47

147407: FROM xla_events_gt xet
147408: , AP_INVOICE_EXTRACT_HEADER_V h2
147409: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
147410: , fnd_lookup_values fvl15
147411: , fnd_lookup_values fvl47
147412: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
147413: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147414: AND xet.event_class_code = C_EVENT_CLASS_CODE
147415: AND h2.event_id = xet.event_id

Line 147754: , fnd_lookup_values fvl22

147750: , AP_INVOICE_EXTRACT_DETAILS_V l1
147751: , AP_PO_HEADERS_EXTRACT_V l3
147752: , ZX_AP_DEF_TAX_EXTRACT_V l5
147753: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
147754: , fnd_lookup_values fvl22
147755: , fnd_lookup_values fvl33
147756: , fnd_lookup_values fvl80
147757: , fnd_lookup_values fvl96
147758: , fnd_lookup_values fvl142

Line 147755: , fnd_lookup_values fvl33

147751: , AP_PO_HEADERS_EXTRACT_V l3
147752: , ZX_AP_DEF_TAX_EXTRACT_V l5
147753: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
147754: , fnd_lookup_values fvl22
147755: , fnd_lookup_values fvl33
147756: , fnd_lookup_values fvl80
147757: , fnd_lookup_values fvl96
147758: , fnd_lookup_values fvl142
147759: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)

Line 147756: , fnd_lookup_values fvl80

147752: , ZX_AP_DEF_TAX_EXTRACT_V l5
147753: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
147754: , fnd_lookup_values fvl22
147755: , fnd_lookup_values fvl33
147756: , fnd_lookup_values fvl80
147757: , fnd_lookup_values fvl96
147758: , fnd_lookup_values fvl142
147759: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
147760: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 147757: , fnd_lookup_values fvl96

147753: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
147754: , fnd_lookup_values fvl22
147755: , fnd_lookup_values fvl33
147756: , fnd_lookup_values fvl80
147757: , fnd_lookup_values fvl96
147758: , fnd_lookup_values fvl142
147759: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
147760: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147761: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 147758: , fnd_lookup_values fvl142

147754: , fnd_lookup_values fvl22
147755: , fnd_lookup_values fvl33
147756: , fnd_lookup_values fvl80
147757: , fnd_lookup_values fvl96
147758: , fnd_lookup_values fvl142
147759: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
147760: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147761: AND xet.event_class_code = C_EVENT_CLASS_CODE
147762: AND l1.event_id = xet.event_id

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

147909: l_balance_type_code VARCHAR2(1) :=NULL;
147910: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
147911:
147912: --
147913: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
147914: --
147915:
147916: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
147917: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 148116: , fnd_lookup_values fvl15

148112: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
148113: FROM xla_events_gt xet
148114: , AP_INVOICE_EXTRACT_HEADER_V h2
148115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
148116: , fnd_lookup_values fvl15
148117: , fnd_lookup_values fvl47
148118: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
148119: and xet.event_class_code = C_EVENT_CLASS_CODE
148120: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 148117: , fnd_lookup_values fvl47

148113: FROM xla_events_gt xet
148114: , AP_INVOICE_EXTRACT_HEADER_V h2
148115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
148116: , fnd_lookup_values fvl15
148117: , fnd_lookup_values fvl47
148118: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
148119: and xet.event_class_code = C_EVENT_CLASS_CODE
148120: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
148121: AND h4.asp_org_id= h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 148220: , fnd_lookup_values fvl22

148216: , AP_INVOICE_EXTRACT_DETAILS_V l1
148217: , AP_PO_HEADERS_EXTRACT_V l3
148218: , ZX_AP_DEF_TAX_EXTRACT_V l5
148219: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
148220: , fnd_lookup_values fvl22
148221: , fnd_lookup_values fvl33
148222: , fnd_lookup_values fvl80
148223: , fnd_lookup_values fvl96
148224: , fnd_lookup_values fvl142

Line 148221: , fnd_lookup_values fvl33

148217: , AP_PO_HEADERS_EXTRACT_V l3
148218: , ZX_AP_DEF_TAX_EXTRACT_V l5
148219: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
148220: , fnd_lookup_values fvl22
148221: , fnd_lookup_values fvl33
148222: , fnd_lookup_values fvl80
148223: , fnd_lookup_values fvl96
148224: , fnd_lookup_values fvl142
148225: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 148222: , fnd_lookup_values fvl80

148218: , ZX_AP_DEF_TAX_EXTRACT_V l5
148219: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
148220: , fnd_lookup_values fvl22
148221: , fnd_lookup_values fvl33
148222: , fnd_lookup_values fvl80
148223: , fnd_lookup_values fvl96
148224: , fnd_lookup_values fvl142
148225: WHERE xet.event_id between x_first_event_id and x_last_event_id
148226: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 148223: , fnd_lookup_values fvl96

148219: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
148220: , fnd_lookup_values fvl22
148221: , fnd_lookup_values fvl33
148222: , fnd_lookup_values fvl80
148223: , fnd_lookup_values fvl96
148224: , fnd_lookup_values fvl142
148225: WHERE xet.event_id between x_first_event_id and x_last_event_id
148226: and xet.event_date between p_pad_start_date and p_pad_end_date
148227: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 148224: , fnd_lookup_values fvl142

148220: , fnd_lookup_values fvl22
148221: , fnd_lookup_values fvl33
148222: , fnd_lookup_values fvl80
148223: , fnd_lookup_values fvl96
148224: , fnd_lookup_values fvl142
148225: WHERE xet.event_id between x_first_event_id and x_last_event_id
148226: and xet.event_date between p_pad_start_date and p_pad_end_date
148227: and xet.event_class_code = C_EVENT_CLASS_CODE
148228: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 150677: , fnd_lookup_values fvl15

150673: END source_meaning
150674: FROM xla_events_gt xet
150675: , AP_PAYMENT_EXTRACT_HEADER_V h2
150676: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
150677: , fnd_lookup_values fvl15
150678: , fnd_lookup_values fvl47
150679: , fnd_lookup_values fvl113
150680: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
150681: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 150678: , fnd_lookup_values fvl47

150674: FROM xla_events_gt xet
150675: , AP_PAYMENT_EXTRACT_HEADER_V h2
150676: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
150677: , fnd_lookup_values fvl15
150678: , fnd_lookup_values fvl47
150679: , fnd_lookup_values fvl113
150680: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
150681: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150682: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 150679: , fnd_lookup_values fvl113

150675: , AP_PAYMENT_EXTRACT_HEADER_V h2
150676: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
150677: , fnd_lookup_values fvl15
150678: , fnd_lookup_values fvl47
150679: , fnd_lookup_values fvl113
150680: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
150681: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150682: AND xet.event_class_code = C_EVENT_CLASS_CODE
150683: AND h2.event_id = xet.event_id

Line 150918: , fnd_lookup_values fvl33

150914: END source_meaning
150915: FROM xla_events_gt xet
150916: , AP_PAYMENT_EXTRACT_DETAILS_V l1
150917: , ZX_AP_DEF_TAX_EXTRACT_V l4
150918: , fnd_lookup_values fvl33
150919: , fnd_lookup_values fvl80
150920: , fnd_lookup_values fvl98
150921: , fnd_lookup_values fvl137
150922: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

Line 150919: , fnd_lookup_values fvl80

150915: FROM xla_events_gt xet
150916: , AP_PAYMENT_EXTRACT_DETAILS_V l1
150917: , ZX_AP_DEF_TAX_EXTRACT_V l4
150918: , fnd_lookup_values fvl33
150919: , fnd_lookup_values fvl80
150920: , fnd_lookup_values fvl98
150921: , fnd_lookup_values fvl137
150922: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
150923: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 150920: , fnd_lookup_values fvl98

150916: , AP_PAYMENT_EXTRACT_DETAILS_V l1
150917: , ZX_AP_DEF_TAX_EXTRACT_V l4
150918: , fnd_lookup_values fvl33
150919: , fnd_lookup_values fvl80
150920: , fnd_lookup_values fvl98
150921: , fnd_lookup_values fvl137
150922: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
150923: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150924: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 150921: , fnd_lookup_values fvl137

150917: , ZX_AP_DEF_TAX_EXTRACT_V l4
150918: , fnd_lookup_values fvl33
150919: , fnd_lookup_values fvl80
150920: , fnd_lookup_values fvl98
150921: , fnd_lookup_values fvl137
150922: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
150923: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150924: AND xet.event_class_code = C_EVENT_CLASS_CODE
150925: AND l1.event_id = xet.event_id

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

151068: l_balance_type_code VARCHAR2(1) :=NULL;
151069: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
151070:
151071: --
151072: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
151073: --
151074:
151075: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
151076: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 151249: , fnd_lookup_values fvl15

151245: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
151246: FROM xla_events_gt xet
151247: , AP_PAYMENT_EXTRACT_HEADER_V h2
151248: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
151249: , fnd_lookup_values fvl15
151250: , fnd_lookup_values fvl47
151251: , fnd_lookup_values fvl113
151252: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
151253: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 151250: , fnd_lookup_values fvl47

151246: FROM xla_events_gt xet
151247: , AP_PAYMENT_EXTRACT_HEADER_V h2
151248: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
151249: , fnd_lookup_values fvl15
151250: , fnd_lookup_values fvl47
151251: , fnd_lookup_values fvl113
151252: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
151253: and xet.event_class_code = C_EVENT_CLASS_CODE
151254: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 151251: , fnd_lookup_values fvl113

151247: , AP_PAYMENT_EXTRACT_HEADER_V h2
151248: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
151249: , fnd_lookup_values fvl15
151250: , fnd_lookup_values fvl47
151251: , fnd_lookup_values fvl113
151252: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
151253: and xet.event_class_code = C_EVENT_CLASS_CODE
151254: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
151255: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 151334: , fnd_lookup_values fvl33

151330: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_161
151331: FROM xla_events_gt xet
151332: , AP_PAYMENT_EXTRACT_DETAILS_V l1
151333: , ZX_AP_DEF_TAX_EXTRACT_V l4
151334: , fnd_lookup_values fvl33
151335: , fnd_lookup_values fvl80
151336: , fnd_lookup_values fvl98
151337: , fnd_lookup_values fvl137
151338: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 151335: , fnd_lookup_values fvl80

151331: FROM xla_events_gt xet
151332: , AP_PAYMENT_EXTRACT_DETAILS_V l1
151333: , ZX_AP_DEF_TAX_EXTRACT_V l4
151334: , fnd_lookup_values fvl33
151335: , fnd_lookup_values fvl80
151336: , fnd_lookup_values fvl98
151337: , fnd_lookup_values fvl137
151338: WHERE xet.event_id between x_first_event_id and x_last_event_id
151339: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 151336: , fnd_lookup_values fvl98

151332: , AP_PAYMENT_EXTRACT_DETAILS_V l1
151333: , ZX_AP_DEF_TAX_EXTRACT_V l4
151334: , fnd_lookup_values fvl33
151335: , fnd_lookup_values fvl80
151336: , fnd_lookup_values fvl98
151337: , fnd_lookup_values fvl137
151338: WHERE xet.event_id between x_first_event_id and x_last_event_id
151339: and xet.event_date between p_pad_start_date and p_pad_end_date
151340: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 151337: , fnd_lookup_values fvl137

151333: , ZX_AP_DEF_TAX_EXTRACT_V l4
151334: , fnd_lookup_values fvl33
151335: , fnd_lookup_values fvl80
151336: , fnd_lookup_values fvl98
151337: , fnd_lookup_values fvl137
151338: WHERE xet.event_id between x_first_event_id and x_last_event_id
151339: and xet.event_date between p_pad_start_date and p_pad_end_date
151340: and xet.event_class_code = C_EVENT_CLASS_CODE
151341: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 153031: , fnd_lookup_values fvl15

153027: END source_meaning
153028: FROM xla_events_gt xet
153029: , AP_INVOICE_EXTRACT_HEADER_V h2
153030: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153031: , fnd_lookup_values fvl15
153032: , fnd_lookup_values fvl47
153033: , fnd_lookup_values fvl165
153034: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
153035: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 153032: , fnd_lookup_values fvl47

153028: FROM xla_events_gt xet
153029: , AP_INVOICE_EXTRACT_HEADER_V h2
153030: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153031: , fnd_lookup_values fvl15
153032: , fnd_lookup_values fvl47
153033: , fnd_lookup_values fvl165
153034: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
153035: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153036: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 153033: , fnd_lookup_values fvl165

153029: , AP_INVOICE_EXTRACT_HEADER_V h2
153030: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153031: , fnd_lookup_values fvl15
153032: , fnd_lookup_values fvl47
153033: , fnd_lookup_values fvl165
153034: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
153035: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153036: AND xet.event_class_code = C_EVENT_CLASS_CODE
153037: AND h2.event_id = xet.event_id

Line 153395: , fnd_lookup_values fvl22

153391: , AP_INVOICE_EXTRACT_DETAILS_V l1
153392: , AP_PO_HEADERS_EXTRACT_V l3
153393: , ZX_AP_DEF_TAX_EXTRACT_V l5
153394: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153395: , fnd_lookup_values fvl22
153396: , fnd_lookup_values fvl33
153397: , fnd_lookup_values fvl80
153398: , fnd_lookup_values fvl96
153399: , fnd_lookup_values fvl142

Line 153396: , fnd_lookup_values fvl33

153392: , AP_PO_HEADERS_EXTRACT_V l3
153393: , ZX_AP_DEF_TAX_EXTRACT_V l5
153394: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153395: , fnd_lookup_values fvl22
153396: , fnd_lookup_values fvl33
153397: , fnd_lookup_values fvl80
153398: , fnd_lookup_values fvl96
153399: , fnd_lookup_values fvl142
153400: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)

Line 153397: , fnd_lookup_values fvl80

153393: , ZX_AP_DEF_TAX_EXTRACT_V l5
153394: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153395: , fnd_lookup_values fvl22
153396: , fnd_lookup_values fvl33
153397: , fnd_lookup_values fvl80
153398: , fnd_lookup_values fvl96
153399: , fnd_lookup_values fvl142
153400: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
153401: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 153398: , fnd_lookup_values fvl96

153394: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153395: , fnd_lookup_values fvl22
153396: , fnd_lookup_values fvl33
153397: , fnd_lookup_values fvl80
153398: , fnd_lookup_values fvl96
153399: , fnd_lookup_values fvl142
153400: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
153401: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153402: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 153399: , fnd_lookup_values fvl142

153395: , fnd_lookup_values fvl22
153396: , fnd_lookup_values fvl33
153397: , fnd_lookup_values fvl80
153398: , fnd_lookup_values fvl96
153399: , fnd_lookup_values fvl142
153400: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
153401: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153402: AND xet.event_class_code = C_EVENT_CLASS_CODE
153403: AND l1.event_id = xet.event_id

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

153550: l_balance_type_code VARCHAR2(1) :=NULL;
153551: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
153552:
153553: --
153554: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153555: --
153556:
153557: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
153558: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 153768: , fnd_lookup_values fvl15

153764: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
153765: FROM xla_events_gt xet
153766: , AP_INVOICE_EXTRACT_HEADER_V h2
153767: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153768: , fnd_lookup_values fvl15
153769: , fnd_lookup_values fvl47
153770: , fnd_lookup_values fvl165
153771: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153772: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 153769: , fnd_lookup_values fvl47

153765: FROM xla_events_gt xet
153766: , AP_INVOICE_EXTRACT_HEADER_V h2
153767: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153768: , fnd_lookup_values fvl15
153769: , fnd_lookup_values fvl47
153770: , fnd_lookup_values fvl165
153771: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153772: and xet.event_class_code = C_EVENT_CLASS_CODE
153773: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 153770: , fnd_lookup_values fvl165

153766: , AP_INVOICE_EXTRACT_HEADER_V h2
153767: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153768: , fnd_lookup_values fvl15
153769: , fnd_lookup_values fvl47
153770: , fnd_lookup_values fvl165
153771: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153772: and xet.event_class_code = C_EVENT_CLASS_CODE
153773: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
153774: AND h4.asp_org_id = h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 153880: , fnd_lookup_values fvl22

153876: , AP_INVOICE_EXTRACT_DETAILS_V l1
153877: , AP_PO_HEADERS_EXTRACT_V l3
153878: , ZX_AP_DEF_TAX_EXTRACT_V l5
153879: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153880: , fnd_lookup_values fvl22
153881: , fnd_lookup_values fvl33
153882: , fnd_lookup_values fvl80
153883: , fnd_lookup_values fvl96
153884: , fnd_lookup_values fvl142

Line 153881: , fnd_lookup_values fvl33

153877: , AP_PO_HEADERS_EXTRACT_V l3
153878: , ZX_AP_DEF_TAX_EXTRACT_V l5
153879: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153880: , fnd_lookup_values fvl22
153881: , fnd_lookup_values fvl33
153882: , fnd_lookup_values fvl80
153883: , fnd_lookup_values fvl96
153884: , fnd_lookup_values fvl142
153885: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 153882: , fnd_lookup_values fvl80

153878: , ZX_AP_DEF_TAX_EXTRACT_V l5
153879: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153880: , fnd_lookup_values fvl22
153881: , fnd_lookup_values fvl33
153882: , fnd_lookup_values fvl80
153883: , fnd_lookup_values fvl96
153884: , fnd_lookup_values fvl142
153885: WHERE xet.event_id between x_first_event_id and x_last_event_id
153886: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 153883: , fnd_lookup_values fvl96

153879: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153880: , fnd_lookup_values fvl22
153881: , fnd_lookup_values fvl33
153882: , fnd_lookup_values fvl80
153883: , fnd_lookup_values fvl96
153884: , fnd_lookup_values fvl142
153885: WHERE xet.event_id between x_first_event_id and x_last_event_id
153886: and xet.event_date between p_pad_start_date and p_pad_end_date
153887: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 153884: , fnd_lookup_values fvl142

153880: , fnd_lookup_values fvl22
153881: , fnd_lookup_values fvl33
153882: , fnd_lookup_values fvl80
153883: , fnd_lookup_values fvl96
153884: , fnd_lookup_values fvl142
153885: WHERE xet.event_id between x_first_event_id and x_last_event_id
153886: and xet.event_date between p_pad_start_date and p_pad_end_date
153887: and xet.event_class_code = C_EVENT_CLASS_CODE
153888: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 156502: , fnd_lookup_values fvl15

156498: END source_meaning
156499: FROM xla_events_gt xet
156500: , AP_PAYMENT_EXTRACT_HEADER_V h2
156501: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
156502: , fnd_lookup_values fvl15
156503: , fnd_lookup_values fvl19
156504: , fnd_lookup_values fvl25
156505: , fnd_lookup_values fvl47
156506: , fnd_lookup_values fvl113

Line 156503: , fnd_lookup_values fvl19

156499: FROM xla_events_gt xet
156500: , AP_PAYMENT_EXTRACT_HEADER_V h2
156501: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
156502: , fnd_lookup_values fvl15
156503: , fnd_lookup_values fvl19
156504: , fnd_lookup_values fvl25
156505: , fnd_lookup_values fvl47
156506: , fnd_lookup_values fvl113
156507: , fnd_lookup_values fvl122

Line 156504: , fnd_lookup_values fvl25

156500: , AP_PAYMENT_EXTRACT_HEADER_V h2
156501: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
156502: , fnd_lookup_values fvl15
156503: , fnd_lookup_values fvl19
156504: , fnd_lookup_values fvl25
156505: , fnd_lookup_values fvl47
156506: , fnd_lookup_values fvl113
156507: , fnd_lookup_values fvl122
156508: , fnd_lookup_values fvl172

Line 156505: , fnd_lookup_values fvl47

156501: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
156502: , fnd_lookup_values fvl15
156503: , fnd_lookup_values fvl19
156504: , fnd_lookup_values fvl25
156505: , fnd_lookup_values fvl47
156506: , fnd_lookup_values fvl113
156507: , fnd_lookup_values fvl122
156508: , fnd_lookup_values fvl172
156509: ,(select rownum r from all_objects where rownum <= 39 and owner = p_apps_owner)

Line 156506: , fnd_lookup_values fvl113

156502: , fnd_lookup_values fvl15
156503: , fnd_lookup_values fvl19
156504: , fnd_lookup_values fvl25
156505: , fnd_lookup_values fvl47
156506: , fnd_lookup_values fvl113
156507: , fnd_lookup_values fvl122
156508: , fnd_lookup_values fvl172
156509: ,(select rownum r from all_objects where rownum <= 39 and owner = p_apps_owner)
156510: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 156507: , fnd_lookup_values fvl122

156503: , fnd_lookup_values fvl19
156504: , fnd_lookup_values fvl25
156505: , fnd_lookup_values fvl47
156506: , fnd_lookup_values fvl113
156507: , fnd_lookup_values fvl122
156508: , fnd_lookup_values fvl172
156509: ,(select rownum r from all_objects where rownum <= 39 and owner = p_apps_owner)
156510: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156511: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 156508: , fnd_lookup_values fvl172

156504: , fnd_lookup_values fvl25
156505: , fnd_lookup_values fvl47
156506: , fnd_lookup_values fvl113
156507: , fnd_lookup_values fvl122
156508: , fnd_lookup_values fvl172
156509: ,(select rownum r from all_objects where rownum <= 39 and owner = p_apps_owner)
156510: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156511: AND xet.event_class_code = C_EVENT_CLASS_CODE
156512: AND h2.event_id = xet.event_id

Line 156811: , fnd_lookup_values fvl33

156807: FROM xla_events_gt xet
156808: , AP_PAYMENT_EXTRACT_DETAILS_V l1
156809: , ZX_AP_DEF_TAX_EXTRACT_V l4
156810: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
156811: , fnd_lookup_values fvl33
156812: , fnd_lookup_values fvl80
156813: , fnd_lookup_values fvl98
156814: , fnd_lookup_values fvl137
156815: , fnd_lookup_values fvl163

Line 156812: , fnd_lookup_values fvl80

156808: , AP_PAYMENT_EXTRACT_DETAILS_V l1
156809: , ZX_AP_DEF_TAX_EXTRACT_V l4
156810: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
156811: , fnd_lookup_values fvl33
156812: , fnd_lookup_values fvl80
156813: , fnd_lookup_values fvl98
156814: , fnd_lookup_values fvl137
156815: , fnd_lookup_values fvl163
156816: , fnd_lookup_values fvl164

Line 156813: , fnd_lookup_values fvl98

156809: , ZX_AP_DEF_TAX_EXTRACT_V l4
156810: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
156811: , fnd_lookup_values fvl33
156812: , fnd_lookup_values fvl80
156813: , fnd_lookup_values fvl98
156814: , fnd_lookup_values fvl137
156815: , fnd_lookup_values fvl163
156816: , fnd_lookup_values fvl164
156817: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)

Line 156814: , fnd_lookup_values fvl137

156810: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
156811: , fnd_lookup_values fvl33
156812: , fnd_lookup_values fvl80
156813: , fnd_lookup_values fvl98
156814: , fnd_lookup_values fvl137
156815: , fnd_lookup_values fvl163
156816: , fnd_lookup_values fvl164
156817: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)
156818: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 156815: , fnd_lookup_values fvl163

156811: , fnd_lookup_values fvl33
156812: , fnd_lookup_values fvl80
156813: , fnd_lookup_values fvl98
156814: , fnd_lookup_values fvl137
156815: , fnd_lookup_values fvl163
156816: , fnd_lookup_values fvl164
156817: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)
156818: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156819: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 156816: , fnd_lookup_values fvl164

156812: , fnd_lookup_values fvl80
156813: , fnd_lookup_values fvl98
156814: , fnd_lookup_values fvl137
156815: , fnd_lookup_values fvl163
156816: , fnd_lookup_values fvl164
156817: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)
156818: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156819: AND xet.event_class_code = C_EVENT_CLASS_CODE
156820: AND l1.event_id = xet.event_id

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

156971: l_balance_type_code VARCHAR2(1) :=NULL;
156972: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
156973:
156974: --
156975: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
156976: --
156977:
156978: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
156979: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 157219: , fnd_lookup_values fvl15

157215: , fvl172.meaning source_172_meaning
157216: FROM xla_events_gt xet
157217: , AP_PAYMENT_EXTRACT_HEADER_V h2
157218: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
157219: , fnd_lookup_values fvl15
157220: , fnd_lookup_values fvl19
157221: , fnd_lookup_values fvl25
157222: , fnd_lookup_values fvl47
157223: , fnd_lookup_values fvl113

Line 157220: , fnd_lookup_values fvl19

157216: FROM xla_events_gt xet
157217: , AP_PAYMENT_EXTRACT_HEADER_V h2
157218: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
157219: , fnd_lookup_values fvl15
157220: , fnd_lookup_values fvl19
157221: , fnd_lookup_values fvl25
157222: , fnd_lookup_values fvl47
157223: , fnd_lookup_values fvl113
157224: , fnd_lookup_values fvl122

Line 157221: , fnd_lookup_values fvl25

157217: , AP_PAYMENT_EXTRACT_HEADER_V h2
157218: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
157219: , fnd_lookup_values fvl15
157220: , fnd_lookup_values fvl19
157221: , fnd_lookup_values fvl25
157222: , fnd_lookup_values fvl47
157223: , fnd_lookup_values fvl113
157224: , fnd_lookup_values fvl122
157225: , fnd_lookup_values fvl172

Line 157222: , fnd_lookup_values fvl47

157218: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
157219: , fnd_lookup_values fvl15
157220: , fnd_lookup_values fvl19
157221: , fnd_lookup_values fvl25
157222: , fnd_lookup_values fvl47
157223: , fnd_lookup_values fvl113
157224: , fnd_lookup_values fvl122
157225: , fnd_lookup_values fvl172
157226: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 157223: , fnd_lookup_values fvl113

157219: , fnd_lookup_values fvl15
157220: , fnd_lookup_values fvl19
157221: , fnd_lookup_values fvl25
157222: , fnd_lookup_values fvl47
157223: , fnd_lookup_values fvl113
157224: , fnd_lookup_values fvl122
157225: , fnd_lookup_values fvl172
157226: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
157227: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 157224: , fnd_lookup_values fvl122

157220: , fnd_lookup_values fvl19
157221: , fnd_lookup_values fvl25
157222: , fnd_lookup_values fvl47
157223: , fnd_lookup_values fvl113
157224: , fnd_lookup_values fvl122
157225: , fnd_lookup_values fvl172
157226: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
157227: and xet.event_class_code = C_EVENT_CLASS_CODE
157228: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 157225: , fnd_lookup_values fvl172

157221: , fnd_lookup_values fvl25
157222: , fnd_lookup_values fvl47
157223: , fnd_lookup_values fvl113
157224: , fnd_lookup_values fvl122
157225: , fnd_lookup_values fvl172
157226: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
157227: and xet.event_class_code = C_EVENT_CLASS_CODE
157228: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
157229: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 157336: , fnd_lookup_values fvl33

157332: FROM xla_events_gt xet
157333: , AP_PAYMENT_EXTRACT_DETAILS_V l1
157334: , ZX_AP_DEF_TAX_EXTRACT_V l4
157335: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
157336: , fnd_lookup_values fvl33
157337: , fnd_lookup_values fvl80
157338: , fnd_lookup_values fvl98
157339: , fnd_lookup_values fvl137
157340: , fnd_lookup_values fvl163

Line 157337: , fnd_lookup_values fvl80

157333: , AP_PAYMENT_EXTRACT_DETAILS_V l1
157334: , ZX_AP_DEF_TAX_EXTRACT_V l4
157335: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
157336: , fnd_lookup_values fvl33
157337: , fnd_lookup_values fvl80
157338: , fnd_lookup_values fvl98
157339: , fnd_lookup_values fvl137
157340: , fnd_lookup_values fvl163
157341: , fnd_lookup_values fvl164

Line 157338: , fnd_lookup_values fvl98

157334: , ZX_AP_DEF_TAX_EXTRACT_V l4
157335: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
157336: , fnd_lookup_values fvl33
157337: , fnd_lookup_values fvl80
157338: , fnd_lookup_values fvl98
157339: , fnd_lookup_values fvl137
157340: , fnd_lookup_values fvl163
157341: , fnd_lookup_values fvl164
157342: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 157339: , fnd_lookup_values fvl137

157335: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
157336: , fnd_lookup_values fvl33
157337: , fnd_lookup_values fvl80
157338: , fnd_lookup_values fvl98
157339: , fnd_lookup_values fvl137
157340: , fnd_lookup_values fvl163
157341: , fnd_lookup_values fvl164
157342: WHERE xet.event_id between x_first_event_id and x_last_event_id
157343: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 157340: , fnd_lookup_values fvl163

157336: , fnd_lookup_values fvl33
157337: , fnd_lookup_values fvl80
157338: , fnd_lookup_values fvl98
157339: , fnd_lookup_values fvl137
157340: , fnd_lookup_values fvl163
157341: , fnd_lookup_values fvl164
157342: WHERE xet.event_id between x_first_event_id and x_last_event_id
157343: and xet.event_date between p_pad_start_date and p_pad_end_date
157344: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 157341: , fnd_lookup_values fvl164

157337: , fnd_lookup_values fvl80
157338: , fnd_lookup_values fvl98
157339: , fnd_lookup_values fvl137
157340: , fnd_lookup_values fvl163
157341: , fnd_lookup_values fvl164
157342: WHERE xet.event_id between x_first_event_id and x_last_event_id
157343: and xet.event_date between p_pad_start_date and p_pad_end_date
157344: and xet.event_class_code = C_EVENT_CLASS_CODE
157345: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 159559: , fnd_lookup_values fvl15

159555: END source_meaning
159556: FROM xla_events_gt xet
159557: , AP_INVOICE_EXTRACT_HEADER_V h1
159558: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
159559: , fnd_lookup_values fvl15
159560: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
159561: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159562: AND xet.event_class_code = C_EVENT_CLASS_CODE
159563: AND h1.event_id = xet.event_id

Line 159906: , fnd_lookup_values fvl80

159902: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
159903: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
159904: , ZX_AP_DEF_TAX_EXTRACT_V l5
159905: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
159906: , fnd_lookup_values fvl80
159907: , fnd_lookup_values fvl126
159908: , fnd_lookup_values fvl137
159909: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
159910: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 159907: , fnd_lookup_values fvl126

159903: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
159904: , ZX_AP_DEF_TAX_EXTRACT_V l5
159905: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
159906: , fnd_lookup_values fvl80
159907: , fnd_lookup_values fvl126
159908: , fnd_lookup_values fvl137
159909: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
159910: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159911: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 159908: , fnd_lookup_values fvl137

159904: , ZX_AP_DEF_TAX_EXTRACT_V l5
159905: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
159906: , fnd_lookup_values fvl80
159907: , fnd_lookup_values fvl126
159908: , fnd_lookup_values fvl137
159909: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
159910: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159911: AND xet.event_class_code = C_EVENT_CLASS_CODE
159912: AND l2.event_id = xet.event_id

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

160051: l_balance_type_code VARCHAR2(1) :=NULL;
160052: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
160053:
160054: --
160055: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
160056: --
160057:
160058: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
160059: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 160255: , fnd_lookup_values fvl15

160251: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_168
160252: FROM xla_events_gt xet
160253: , AP_INVOICE_EXTRACT_HEADER_V h1
160254: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
160255: , fnd_lookup_values fvl15
160256: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160257: and xet.event_class_code = C_EVENT_CLASS_CODE
160258: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
160259: AND h4.asp_org_id = h1.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 160354: , fnd_lookup_values fvl80

160350: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
160351: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
160352: , ZX_AP_DEF_TAX_EXTRACT_V l5
160353: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
160354: , fnd_lookup_values fvl80
160355: , fnd_lookup_values fvl126
160356: , fnd_lookup_values fvl137
160357: WHERE xet.event_id between x_first_event_id and x_last_event_id
160358: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 160355: , fnd_lookup_values fvl126

160351: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
160352: , ZX_AP_DEF_TAX_EXTRACT_V l5
160353: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
160354: , fnd_lookup_values fvl80
160355: , fnd_lookup_values fvl126
160356: , fnd_lookup_values fvl137
160357: WHERE xet.event_id between x_first_event_id and x_last_event_id
160358: and xet.event_date between p_pad_start_date and p_pad_end_date
160359: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 160356: , fnd_lookup_values fvl137

160352: , ZX_AP_DEF_TAX_EXTRACT_V l5
160353: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
160354: , fnd_lookup_values fvl80
160355: , fnd_lookup_values fvl126
160356: , fnd_lookup_values fvl137
160357: WHERE xet.event_id between x_first_event_id and x_last_event_id
160358: and xet.event_date between p_pad_start_date and p_pad_end_date
160359: and xet.event_class_code = C_EVENT_CLASS_CODE
160360: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 161987: , fnd_lookup_values fvl15

161983: END source_meaning
161984: FROM xla_events_gt xet
161985: , AP_INVOICE_EXTRACT_HEADER_V h2
161986: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161987: , fnd_lookup_values fvl15
161988: , fnd_lookup_values fvl31
161989: , fnd_lookup_values fvl47
161990: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
161991: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 161988: , fnd_lookup_values fvl31

161984: FROM xla_events_gt xet
161985: , AP_INVOICE_EXTRACT_HEADER_V h2
161986: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161987: , fnd_lookup_values fvl15
161988: , fnd_lookup_values fvl31
161989: , fnd_lookup_values fvl47
161990: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
161991: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161992: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 161989: , fnd_lookup_values fvl47

161985: , AP_INVOICE_EXTRACT_HEADER_V h2
161986: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161987: , fnd_lookup_values fvl15
161988: , fnd_lookup_values fvl31
161989: , fnd_lookup_values fvl47
161990: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
161991: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161992: AND xet.event_class_code = C_EVENT_CLASS_CODE
161993: AND h2.event_id = xet.event_id

Line 162327: , fnd_lookup_values fvl22

162323: , AP_INVOICE_EXTRACT_DETAILS_V l1
162324: , AP_PO_HEADERS_EXTRACT_V l3
162325: , ZX_AP_DEF_TAX_EXTRACT_V l5
162326: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162327: , fnd_lookup_values fvl22
162328: , fnd_lookup_values fvl33
162329: , fnd_lookup_values fvl80
162330: , fnd_lookup_values fvl96
162331: , fnd_lookup_values fvl137

Line 162328: , fnd_lookup_values fvl33

162324: , AP_PO_HEADERS_EXTRACT_V l3
162325: , ZX_AP_DEF_TAX_EXTRACT_V l5
162326: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162327: , fnd_lookup_values fvl22
162328: , fnd_lookup_values fvl33
162329: , fnd_lookup_values fvl80
162330: , fnd_lookup_values fvl96
162331: , fnd_lookup_values fvl137
162332: , fnd_lookup_values fvl142

Line 162329: , fnd_lookup_values fvl80

162325: , ZX_AP_DEF_TAX_EXTRACT_V l5
162326: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162327: , fnd_lookup_values fvl22
162328: , fnd_lookup_values fvl33
162329: , fnd_lookup_values fvl80
162330: , fnd_lookup_values fvl96
162331: , fnd_lookup_values fvl137
162332: , fnd_lookup_values fvl142
162333: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)

Line 162330: , fnd_lookup_values fvl96

162326: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162327: , fnd_lookup_values fvl22
162328: , fnd_lookup_values fvl33
162329: , fnd_lookup_values fvl80
162330: , fnd_lookup_values fvl96
162331: , fnd_lookup_values fvl137
162332: , fnd_lookup_values fvl142
162333: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)
162334: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 162331: , fnd_lookup_values fvl137

162327: , fnd_lookup_values fvl22
162328: , fnd_lookup_values fvl33
162329: , fnd_lookup_values fvl80
162330: , fnd_lookup_values fvl96
162331: , fnd_lookup_values fvl137
162332: , fnd_lookup_values fvl142
162333: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)
162334: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162335: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 162332: , fnd_lookup_values fvl142

162328: , fnd_lookup_values fvl33
162329: , fnd_lookup_values fvl80
162330: , fnd_lookup_values fvl96
162331: , fnd_lookup_values fvl137
162332: , fnd_lookup_values fvl142
162333: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)
162334: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162335: AND xet.event_class_code = C_EVENT_CLASS_CODE
162336: AND l1.event_id = xet.event_id

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

162487: l_balance_type_code VARCHAR2(1) :=NULL;
162488: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
162489:
162490: --
162491: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
162492: --
162493:
162494: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
162495: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 162693: , fnd_lookup_values fvl15

162689: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
162690: FROM xla_events_gt xet
162691: , AP_INVOICE_EXTRACT_HEADER_V h2
162692: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162693: , fnd_lookup_values fvl15
162694: , fnd_lookup_values fvl31
162695: , fnd_lookup_values fvl47
162696: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162697: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 162694: , fnd_lookup_values fvl31

162690: FROM xla_events_gt xet
162691: , AP_INVOICE_EXTRACT_HEADER_V h2
162692: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162693: , fnd_lookup_values fvl15
162694: , fnd_lookup_values fvl31
162695: , fnd_lookup_values fvl47
162696: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162697: and xet.event_class_code = C_EVENT_CLASS_CODE
162698: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 162695: , fnd_lookup_values fvl47

162691: , AP_INVOICE_EXTRACT_HEADER_V h2
162692: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162693: , fnd_lookup_values fvl15
162694: , fnd_lookup_values fvl31
162695: , fnd_lookup_values fvl47
162696: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162697: and xet.event_class_code = C_EVENT_CLASS_CODE
162698: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
162699: AND h4.asp_org_id = h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 162801: , fnd_lookup_values fvl22

162797: , AP_INVOICE_EXTRACT_DETAILS_V l1
162798: , AP_PO_HEADERS_EXTRACT_V l3
162799: , ZX_AP_DEF_TAX_EXTRACT_V l5
162800: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162801: , fnd_lookup_values fvl22
162802: , fnd_lookup_values fvl33
162803: , fnd_lookup_values fvl80
162804: , fnd_lookup_values fvl96
162805: , fnd_lookup_values fvl137

Line 162802: , fnd_lookup_values fvl33

162798: , AP_PO_HEADERS_EXTRACT_V l3
162799: , ZX_AP_DEF_TAX_EXTRACT_V l5
162800: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162801: , fnd_lookup_values fvl22
162802: , fnd_lookup_values fvl33
162803: , fnd_lookup_values fvl80
162804: , fnd_lookup_values fvl96
162805: , fnd_lookup_values fvl137
162806: , fnd_lookup_values fvl142

Line 162803: , fnd_lookup_values fvl80

162799: , ZX_AP_DEF_TAX_EXTRACT_V l5
162800: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162801: , fnd_lookup_values fvl22
162802: , fnd_lookup_values fvl33
162803: , fnd_lookup_values fvl80
162804: , fnd_lookup_values fvl96
162805: , fnd_lookup_values fvl137
162806: , fnd_lookup_values fvl142
162807: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 162804: , fnd_lookup_values fvl96

162800: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162801: , fnd_lookup_values fvl22
162802: , fnd_lookup_values fvl33
162803: , fnd_lookup_values fvl80
162804: , fnd_lookup_values fvl96
162805: , fnd_lookup_values fvl137
162806: , fnd_lookup_values fvl142
162807: WHERE xet.event_id between x_first_event_id and x_last_event_id
162808: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 162805: , fnd_lookup_values fvl137

162801: , fnd_lookup_values fvl22
162802: , fnd_lookup_values fvl33
162803: , fnd_lookup_values fvl80
162804: , fnd_lookup_values fvl96
162805: , fnd_lookup_values fvl137
162806: , fnd_lookup_values fvl142
162807: WHERE xet.event_id between x_first_event_id and x_last_event_id
162808: and xet.event_date between p_pad_start_date and p_pad_end_date
162809: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 162806: , fnd_lookup_values fvl142

162802: , fnd_lookup_values fvl33
162803: , fnd_lookup_values fvl80
162804: , fnd_lookup_values fvl96
162805: , fnd_lookup_values fvl137
162806: , fnd_lookup_values fvl142
162807: WHERE xet.event_id between x_first_event_id and x_last_event_id
162808: and xet.event_date between p_pad_start_date and p_pad_end_date
162809: and xet.event_class_code = C_EVENT_CLASS_CODE
162810: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 165350: , fnd_lookup_values fvl15

165346: END source_meaning
165347: FROM xla_events_gt xet
165348: , AP_PAYMENT_EXTRACT_HEADER_V h2
165349: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165350: , fnd_lookup_values fvl15
165351: , fnd_lookup_values fvl19
165352: , fnd_lookup_values fvl47
165353: , fnd_lookup_values fvl113
165354: , fnd_lookup_values fvl122

Line 165351: , fnd_lookup_values fvl19

165347: FROM xla_events_gt xet
165348: , AP_PAYMENT_EXTRACT_HEADER_V h2
165349: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165350: , fnd_lookup_values fvl15
165351: , fnd_lookup_values fvl19
165352: , fnd_lookup_values fvl47
165353: , fnd_lookup_values fvl113
165354: , fnd_lookup_values fvl122
165355: ,(select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)

Line 165352: , fnd_lookup_values fvl47

165348: , AP_PAYMENT_EXTRACT_HEADER_V h2
165349: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165350: , fnd_lookup_values fvl15
165351: , fnd_lookup_values fvl19
165352: , fnd_lookup_values fvl47
165353: , fnd_lookup_values fvl113
165354: , fnd_lookup_values fvl122
165355: ,(select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)
165356: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 165353: , fnd_lookup_values fvl113

165349: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165350: , fnd_lookup_values fvl15
165351: , fnd_lookup_values fvl19
165352: , fnd_lookup_values fvl47
165353: , fnd_lookup_values fvl113
165354: , fnd_lookup_values fvl122
165355: ,(select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)
165356: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165357: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 165354: , fnd_lookup_values fvl122

165350: , fnd_lookup_values fvl15
165351: , fnd_lookup_values fvl19
165352: , fnd_lookup_values fvl47
165353: , fnd_lookup_values fvl113
165354: , fnd_lookup_values fvl122
165355: ,(select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)
165356: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165357: AND xet.event_class_code = C_EVENT_CLASS_CODE
165358: AND h2.event_id = xet.event_id

Line 165688: , fnd_lookup_values fvl33

165684: END source_meaning
165685: FROM xla_events_gt xet
165686: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165687: , ZX_AP_DEF_TAX_EXTRACT_V l4
165688: , fnd_lookup_values fvl33
165689: , fnd_lookup_values fvl80
165690: , fnd_lookup_values fvl98
165691: , fnd_lookup_values fvl137
165692: , fnd_lookup_values fvl163

Line 165689: , fnd_lookup_values fvl80

165685: FROM xla_events_gt xet
165686: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165687: , ZX_AP_DEF_TAX_EXTRACT_V l4
165688: , fnd_lookup_values fvl33
165689: , fnd_lookup_values fvl80
165690: , fnd_lookup_values fvl98
165691: , fnd_lookup_values fvl137
165692: , fnd_lookup_values fvl163
165693: , fnd_lookup_values fvl164

Line 165690: , fnd_lookup_values fvl98

165686: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165687: , ZX_AP_DEF_TAX_EXTRACT_V l4
165688: , fnd_lookup_values fvl33
165689: , fnd_lookup_values fvl80
165690: , fnd_lookup_values fvl98
165691: , fnd_lookup_values fvl137
165692: , fnd_lookup_values fvl163
165693: , fnd_lookup_values fvl164
165694: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)

Line 165691: , fnd_lookup_values fvl137

165687: , ZX_AP_DEF_TAX_EXTRACT_V l4
165688: , fnd_lookup_values fvl33
165689: , fnd_lookup_values fvl80
165690: , fnd_lookup_values fvl98
165691: , fnd_lookup_values fvl137
165692: , fnd_lookup_values fvl163
165693: , fnd_lookup_values fvl164
165694: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
165695: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 165692: , fnd_lookup_values fvl163

165688: , fnd_lookup_values fvl33
165689: , fnd_lookup_values fvl80
165690: , fnd_lookup_values fvl98
165691: , fnd_lookup_values fvl137
165692: , fnd_lookup_values fvl163
165693: , fnd_lookup_values fvl164
165694: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
165695: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165696: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 165693: , fnd_lookup_values fvl164

165689: , fnd_lookup_values fvl80
165690: , fnd_lookup_values fvl98
165691: , fnd_lookup_values fvl137
165692: , fnd_lookup_values fvl163
165693: , fnd_lookup_values fvl164
165694: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
165695: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165696: AND xet.event_class_code = C_EVENT_CLASS_CODE
165697: AND l1.event_id = xet.event_id

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

165848: l_balance_type_code VARCHAR2(1) :=NULL;
165849: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
165850:
165851: --
165852: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
165853: --
165854:
165855: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
165856: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 166102: , fnd_lookup_values fvl15

166098: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
166099: FROM xla_events_gt xet
166100: , AP_PAYMENT_EXTRACT_HEADER_V h2
166101: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
166102: , fnd_lookup_values fvl15
166103: , fnd_lookup_values fvl19
166104: , fnd_lookup_values fvl47
166105: , fnd_lookup_values fvl113
166106: , fnd_lookup_values fvl122

Line 166103: , fnd_lookup_values fvl19

166099: FROM xla_events_gt xet
166100: , AP_PAYMENT_EXTRACT_HEADER_V h2
166101: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
166102: , fnd_lookup_values fvl15
166103: , fnd_lookup_values fvl19
166104: , fnd_lookup_values fvl47
166105: , fnd_lookup_values fvl113
166106: , fnd_lookup_values fvl122
166107: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 166104: , fnd_lookup_values fvl47

166100: , AP_PAYMENT_EXTRACT_HEADER_V h2
166101: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
166102: , fnd_lookup_values fvl15
166103: , fnd_lookup_values fvl19
166104: , fnd_lookup_values fvl47
166105: , fnd_lookup_values fvl113
166106: , fnd_lookup_values fvl122
166107: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
166108: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 166105: , fnd_lookup_values fvl113

166101: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
166102: , fnd_lookup_values fvl15
166103: , fnd_lookup_values fvl19
166104: , fnd_lookup_values fvl47
166105: , fnd_lookup_values fvl113
166106: , fnd_lookup_values fvl122
166107: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
166108: and xet.event_class_code = C_EVENT_CLASS_CODE
166109: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 166106: , fnd_lookup_values fvl122

166102: , fnd_lookup_values fvl15
166103: , fnd_lookup_values fvl19
166104: , fnd_lookup_values fvl47
166105: , fnd_lookup_values fvl113
166106: , fnd_lookup_values fvl122
166107: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
166108: and xet.event_class_code = C_EVENT_CLASS_CODE
166109: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
166110: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 166216: , fnd_lookup_values fvl33

166212: , fvl164.meaning source_164_meaning
166213: FROM xla_events_gt xet
166214: , AP_PAYMENT_EXTRACT_DETAILS_V l1
166215: , ZX_AP_DEF_TAX_EXTRACT_V l4
166216: , fnd_lookup_values fvl33
166217: , fnd_lookup_values fvl80
166218: , fnd_lookup_values fvl98
166219: , fnd_lookup_values fvl137
166220: , fnd_lookup_values fvl163

Line 166217: , fnd_lookup_values fvl80

166213: FROM xla_events_gt xet
166214: , AP_PAYMENT_EXTRACT_DETAILS_V l1
166215: , ZX_AP_DEF_TAX_EXTRACT_V l4
166216: , fnd_lookup_values fvl33
166217: , fnd_lookup_values fvl80
166218: , fnd_lookup_values fvl98
166219: , fnd_lookup_values fvl137
166220: , fnd_lookup_values fvl163
166221: , fnd_lookup_values fvl164

Line 166218: , fnd_lookup_values fvl98

166214: , AP_PAYMENT_EXTRACT_DETAILS_V l1
166215: , ZX_AP_DEF_TAX_EXTRACT_V l4
166216: , fnd_lookup_values fvl33
166217: , fnd_lookup_values fvl80
166218: , fnd_lookup_values fvl98
166219: , fnd_lookup_values fvl137
166220: , fnd_lookup_values fvl163
166221: , fnd_lookup_values fvl164
166222: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 166219: , fnd_lookup_values fvl137

166215: , ZX_AP_DEF_TAX_EXTRACT_V l4
166216: , fnd_lookup_values fvl33
166217: , fnd_lookup_values fvl80
166218: , fnd_lookup_values fvl98
166219: , fnd_lookup_values fvl137
166220: , fnd_lookup_values fvl163
166221: , fnd_lookup_values fvl164
166222: WHERE xet.event_id between x_first_event_id and x_last_event_id
166223: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 166220: , fnd_lookup_values fvl163

166216: , fnd_lookup_values fvl33
166217: , fnd_lookup_values fvl80
166218: , fnd_lookup_values fvl98
166219: , fnd_lookup_values fvl137
166220: , fnd_lookup_values fvl163
166221: , fnd_lookup_values fvl164
166222: WHERE xet.event_id between x_first_event_id and x_last_event_id
166223: and xet.event_date between p_pad_start_date and p_pad_end_date
166224: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 166221: , fnd_lookup_values fvl164

166217: , fnd_lookup_values fvl80
166218: , fnd_lookup_values fvl98
166219: , fnd_lookup_values fvl137
166220: , fnd_lookup_values fvl163
166221: , fnd_lookup_values fvl164
166222: WHERE xet.event_id between x_first_event_id and x_last_event_id
166223: and xet.event_date between p_pad_start_date and p_pad_end_date
166224: and xet.event_class_code = C_EVENT_CLASS_CODE
166225: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 168465: , fnd_lookup_values fvl15

168461: END source_meaning
168462: FROM xla_events_gt xet
168463: , AP_PAYMENT_EXTRACT_HEADER_V h2
168464: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168465: , fnd_lookup_values fvl15
168466: , fnd_lookup_values fvl19
168467: , fnd_lookup_values fvl47
168468: , fnd_lookup_values fvl113
168469: , fnd_lookup_values fvl122

Line 168466: , fnd_lookup_values fvl19

168462: FROM xla_events_gt xet
168463: , AP_PAYMENT_EXTRACT_HEADER_V h2
168464: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168465: , fnd_lookup_values fvl15
168466: , fnd_lookup_values fvl19
168467: , fnd_lookup_values fvl47
168468: , fnd_lookup_values fvl113
168469: , fnd_lookup_values fvl122
168470: , fnd_lookup_values fvl172

Line 168467: , fnd_lookup_values fvl47

168463: , AP_PAYMENT_EXTRACT_HEADER_V h2
168464: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168465: , fnd_lookup_values fvl15
168466: , fnd_lookup_values fvl19
168467: , fnd_lookup_values fvl47
168468: , fnd_lookup_values fvl113
168469: , fnd_lookup_values fvl122
168470: , fnd_lookup_values fvl172
168471: ,(select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)

Line 168468: , fnd_lookup_values fvl113

168464: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168465: , fnd_lookup_values fvl15
168466: , fnd_lookup_values fvl19
168467: , fnd_lookup_values fvl47
168468: , fnd_lookup_values fvl113
168469: , fnd_lookup_values fvl122
168470: , fnd_lookup_values fvl172
168471: ,(select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
168472: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 168469: , fnd_lookup_values fvl122

168465: , fnd_lookup_values fvl15
168466: , fnd_lookup_values fvl19
168467: , fnd_lookup_values fvl47
168468: , fnd_lookup_values fvl113
168469: , fnd_lookup_values fvl122
168470: , fnd_lookup_values fvl172
168471: ,(select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
168472: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168473: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 168470: , fnd_lookup_values fvl172

168466: , fnd_lookup_values fvl19
168467: , fnd_lookup_values fvl47
168468: , fnd_lookup_values fvl113
168469: , fnd_lookup_values fvl122
168470: , fnd_lookup_values fvl172
168471: ,(select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
168472: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168473: AND xet.event_class_code = C_EVENT_CLASS_CODE
168474: AND h2.event_id = xet.event_id

Line 168731: , fnd_lookup_values fvl33

168727: FROM xla_events_gt xet
168728: , AP_PAYMENT_EXTRACT_DETAILS_V l1
168729: , ZX_AP_DEF_TAX_EXTRACT_V l4
168730: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
168731: , fnd_lookup_values fvl33
168732: , fnd_lookup_values fvl80
168733: , fnd_lookup_values fvl98
168734: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
168735: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 168732: , fnd_lookup_values fvl80

168728: , AP_PAYMENT_EXTRACT_DETAILS_V l1
168729: , ZX_AP_DEF_TAX_EXTRACT_V l4
168730: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
168731: , fnd_lookup_values fvl33
168732: , fnd_lookup_values fvl80
168733: , fnd_lookup_values fvl98
168734: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
168735: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168736: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 168733: , fnd_lookup_values fvl98

168729: , ZX_AP_DEF_TAX_EXTRACT_V l4
168730: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
168731: , fnd_lookup_values fvl33
168732: , fnd_lookup_values fvl80
168733: , fnd_lookup_values fvl98
168734: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
168735: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168736: AND xet.event_class_code = C_EVENT_CLASS_CODE
168737: AND l1.event_id = xet.event_id

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

168876: l_balance_type_code VARCHAR2(1) :=NULL;
168877: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
168878:
168879: --
168880: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
168881: --
168882:
168883: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
168884: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 169081: , fnd_lookup_values fvl15

169077: , fvl172.meaning source_172_meaning
169078: FROM xla_events_gt xet
169079: , AP_PAYMENT_EXTRACT_HEADER_V h2
169080: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
169081: , fnd_lookup_values fvl15
169082: , fnd_lookup_values fvl19
169083: , fnd_lookup_values fvl47
169084: , fnd_lookup_values fvl113
169085: , fnd_lookup_values fvl122

Line 169082: , fnd_lookup_values fvl19

169078: FROM xla_events_gt xet
169079: , AP_PAYMENT_EXTRACT_HEADER_V h2
169080: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
169081: , fnd_lookup_values fvl15
169082: , fnd_lookup_values fvl19
169083: , fnd_lookup_values fvl47
169084: , fnd_lookup_values fvl113
169085: , fnd_lookup_values fvl122
169086: , fnd_lookup_values fvl172

Line 169083: , fnd_lookup_values fvl47

169079: , AP_PAYMENT_EXTRACT_HEADER_V h2
169080: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
169081: , fnd_lookup_values fvl15
169082: , fnd_lookup_values fvl19
169083: , fnd_lookup_values fvl47
169084: , fnd_lookup_values fvl113
169085: , fnd_lookup_values fvl122
169086: , fnd_lookup_values fvl172
169087: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 169084: , fnd_lookup_values fvl113

169080: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
169081: , fnd_lookup_values fvl15
169082: , fnd_lookup_values fvl19
169083: , fnd_lookup_values fvl47
169084: , fnd_lookup_values fvl113
169085: , fnd_lookup_values fvl122
169086: , fnd_lookup_values fvl172
169087: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
169088: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 169085: , fnd_lookup_values fvl122

169081: , fnd_lookup_values fvl15
169082: , fnd_lookup_values fvl19
169083: , fnd_lookup_values fvl47
169084: , fnd_lookup_values fvl113
169085: , fnd_lookup_values fvl122
169086: , fnd_lookup_values fvl172
169087: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
169088: and xet.event_class_code = C_EVENT_CLASS_CODE
169089: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 169086: , fnd_lookup_values fvl172

169082: , fnd_lookup_values fvl19
169083: , fnd_lookup_values fvl47
169084: , fnd_lookup_values fvl113
169085: , fnd_lookup_values fvl122
169086: , fnd_lookup_values fvl172
169087: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
169088: and xet.event_class_code = C_EVENT_CLASS_CODE
169089: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
169090: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 169183: , fnd_lookup_values fvl33

169179: FROM xla_events_gt xet
169180: , AP_PAYMENT_EXTRACT_DETAILS_V l1
169181: , ZX_AP_DEF_TAX_EXTRACT_V l4
169182: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
169183: , fnd_lookup_values fvl33
169184: , fnd_lookup_values fvl80
169185: , fnd_lookup_values fvl98
169186: WHERE xet.event_id between x_first_event_id and x_last_event_id
169187: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 169184: , fnd_lookup_values fvl80

169180: , AP_PAYMENT_EXTRACT_DETAILS_V l1
169181: , ZX_AP_DEF_TAX_EXTRACT_V l4
169182: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
169183: , fnd_lookup_values fvl33
169184: , fnd_lookup_values fvl80
169185: , fnd_lookup_values fvl98
169186: WHERE xet.event_id between x_first_event_id and x_last_event_id
169187: and xet.event_date between p_pad_start_date and p_pad_end_date
169188: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 169185: , fnd_lookup_values fvl98

169181: , ZX_AP_DEF_TAX_EXTRACT_V l4
169182: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
169183: , fnd_lookup_values fvl33
169184: , fnd_lookup_values fvl80
169185: , fnd_lookup_values fvl98
169186: WHERE xet.event_id between x_first_event_id and x_last_event_id
169187: and xet.event_date between p_pad_start_date and p_pad_end_date
169188: and xet.event_class_code = C_EVENT_CLASS_CODE
169189: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id