eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00200_AAD_S_000006_PKG dependencies on FND_LOOKUP_VALUES

Line 182679: , fnd_lookup_values fvl3

182675: END source_meaning
182676: FROM xla_events_gt xet
182677: , AP_INVOICE_EXTRACT_HEADER_V h2
182678: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
182679: , fnd_lookup_values fvl3
182680: , fnd_lookup_values fvl35
182681: , fnd_lookup_values fvl86
182682: , fnd_lookup_values fvl159
182683: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)

Line 182680: , fnd_lookup_values fvl35

182676: FROM xla_events_gt xet
182677: , AP_INVOICE_EXTRACT_HEADER_V h2
182678: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
182679: , fnd_lookup_values fvl3
182680: , fnd_lookup_values fvl35
182681: , fnd_lookup_values fvl86
182682: , fnd_lookup_values fvl159
182683: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
182684: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 182681: , fnd_lookup_values fvl86

182677: , AP_INVOICE_EXTRACT_HEADER_V h2
182678: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
182679: , fnd_lookup_values fvl3
182680: , fnd_lookup_values fvl35
182681: , fnd_lookup_values fvl86
182682: , fnd_lookup_values fvl159
182683: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
182684: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182685: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 182682: , fnd_lookup_values fvl159

182678: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
182679: , fnd_lookup_values fvl3
182680: , fnd_lookup_values fvl35
182681: , fnd_lookup_values fvl86
182682: , fnd_lookup_values fvl159
182683: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
182684: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182685: AND xet.event_class_code = C_EVENT_CLASS_CODE
182686: AND h2.event_id = xet.event_id

Line 183074: , fnd_lookup_values fvl10

183070: , AP_INVOICE_EXTRACT_DETAILS_V l1
183071: , AP_PO_HEADERS_EXTRACT_V l3
183072: , ZX_AP_DEF_TAX_EXTRACT_V l5
183073: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
183074: , fnd_lookup_values fvl10
183075: , fnd_lookup_values fvl21
183076: , fnd_lookup_values fvl68
183077: , fnd_lookup_values fvl84
183078: , fnd_lookup_values fvl87

Line 183075: , fnd_lookup_values fvl21

183071: , AP_PO_HEADERS_EXTRACT_V l3
183072: , ZX_AP_DEF_TAX_EXTRACT_V l5
183073: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
183074: , fnd_lookup_values fvl10
183075: , fnd_lookup_values fvl21
183076: , fnd_lookup_values fvl68
183077: , fnd_lookup_values fvl84
183078: , fnd_lookup_values fvl87
183079: , fnd_lookup_values fvl135

Line 183076: , fnd_lookup_values fvl68

183072: , ZX_AP_DEF_TAX_EXTRACT_V l5
183073: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
183074: , fnd_lookup_values fvl10
183075: , fnd_lookup_values fvl21
183076: , fnd_lookup_values fvl68
183077: , fnd_lookup_values fvl84
183078: , fnd_lookup_values fvl87
183079: , fnd_lookup_values fvl135
183080: , (select rownum r from all_objects where rownum <= 54 and owner = p_apps_owner)

Line 183077: , fnd_lookup_values fvl84

183073: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
183074: , fnd_lookup_values fvl10
183075: , fnd_lookup_values fvl21
183076: , fnd_lookup_values fvl68
183077: , fnd_lookup_values fvl84
183078: , fnd_lookup_values fvl87
183079: , fnd_lookup_values fvl135
183080: , (select rownum r from all_objects where rownum <= 54 and owner = p_apps_owner)
183081: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 183078: , fnd_lookup_values fvl87

183074: , fnd_lookup_values fvl10
183075: , fnd_lookup_values fvl21
183076: , fnd_lookup_values fvl68
183077: , fnd_lookup_values fvl84
183078: , fnd_lookup_values fvl87
183079: , fnd_lookup_values fvl135
183080: , (select rownum r from all_objects where rownum <= 54 and owner = p_apps_owner)
183081: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
183082: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 183079: , fnd_lookup_values fvl135

183075: , fnd_lookup_values fvl21
183076: , fnd_lookup_values fvl68
183077: , fnd_lookup_values fvl84
183078: , fnd_lookup_values fvl87
183079: , fnd_lookup_values fvl135
183080: , (select rownum r from all_objects where rownum <= 54 and owner = p_apps_owner)
183081: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
183082: AND xet.event_class_code = C_EVENT_CLASS_CODE
183083: AND l1.event_id = xet.event_id

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

183234: l_balance_type_code VARCHAR2(1) :=NULL;
183235: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
183236:
183237: --
183238: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
183239: --
183240:
183241: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
183242: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 183456: , fnd_lookup_values fvl3

183452: , h2.INV_DOC_SEQUENCE_VALUE source_167
183453: FROM xla_events_gt xet
183454: , AP_INVOICE_EXTRACT_HEADER_V h2
183455: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
183456: , fnd_lookup_values fvl3
183457: , fnd_lookup_values fvl35
183458: , fnd_lookup_values fvl86
183459: , fnd_lookup_values fvl159
183460: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 183457: , fnd_lookup_values fvl35

183453: FROM xla_events_gt xet
183454: , AP_INVOICE_EXTRACT_HEADER_V h2
183455: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
183456: , fnd_lookup_values fvl3
183457: , fnd_lookup_values fvl35
183458: , fnd_lookup_values fvl86
183459: , fnd_lookup_values fvl159
183460: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
183461: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 183458: , fnd_lookup_values fvl86

183454: , AP_INVOICE_EXTRACT_HEADER_V h2
183455: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
183456: , fnd_lookup_values fvl3
183457: , fnd_lookup_values fvl35
183458: , fnd_lookup_values fvl86
183459: , fnd_lookup_values fvl159
183460: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
183461: and xet.event_class_code = C_EVENT_CLASS_CODE
183462: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 183459: , fnd_lookup_values fvl159

183455: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
183456: , fnd_lookup_values fvl3
183457: , fnd_lookup_values fvl35
183458: , fnd_lookup_values fvl86
183459: , fnd_lookup_values fvl159
183460: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
183461: and xet.event_class_code = C_EVENT_CLASS_CODE
183462: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
183463: AND h4.asp_org_id = h2.ai_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 183579: , fnd_lookup_values fvl10

183575: , AP_INVOICE_EXTRACT_DETAILS_V l1
183576: , AP_PO_HEADERS_EXTRACT_V l3
183577: , ZX_AP_DEF_TAX_EXTRACT_V l5
183578: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
183579: , fnd_lookup_values fvl10
183580: , fnd_lookup_values fvl21
183581: , fnd_lookup_values fvl68
183582: , fnd_lookup_values fvl84
183583: , fnd_lookup_values fvl87

Line 183580: , fnd_lookup_values fvl21

183576: , AP_PO_HEADERS_EXTRACT_V l3
183577: , ZX_AP_DEF_TAX_EXTRACT_V l5
183578: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
183579: , fnd_lookup_values fvl10
183580: , fnd_lookup_values fvl21
183581: , fnd_lookup_values fvl68
183582: , fnd_lookup_values fvl84
183583: , fnd_lookup_values fvl87
183584: , fnd_lookup_values fvl135

Line 183581: , fnd_lookup_values fvl68

183577: , ZX_AP_DEF_TAX_EXTRACT_V l5
183578: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
183579: , fnd_lookup_values fvl10
183580: , fnd_lookup_values fvl21
183581: , fnd_lookup_values fvl68
183582: , fnd_lookup_values fvl84
183583: , fnd_lookup_values fvl87
183584: , fnd_lookup_values fvl135
183585: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 183582: , fnd_lookup_values fvl84

183578: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
183579: , fnd_lookup_values fvl10
183580: , fnd_lookup_values fvl21
183581: , fnd_lookup_values fvl68
183582: , fnd_lookup_values fvl84
183583: , fnd_lookup_values fvl87
183584: , fnd_lookup_values fvl135
183585: WHERE xet.event_id between x_first_event_id and x_last_event_id
183586: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 183583: , fnd_lookup_values fvl87

183579: , fnd_lookup_values fvl10
183580: , fnd_lookup_values fvl21
183581: , fnd_lookup_values fvl68
183582: , fnd_lookup_values fvl84
183583: , fnd_lookup_values fvl87
183584: , fnd_lookup_values fvl135
183585: WHERE xet.event_id between x_first_event_id and x_last_event_id
183586: and xet.event_date between p_pad_start_date and p_pad_end_date
183587: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 183584: , fnd_lookup_values fvl135

183580: , fnd_lookup_values fvl21
183581: , fnd_lookup_values fvl68
183582: , fnd_lookup_values fvl84
183583: , fnd_lookup_values fvl87
183584: , fnd_lookup_values fvl135
183585: WHERE xet.event_id between x_first_event_id and x_last_event_id
183586: and xet.event_date between p_pad_start_date and p_pad_end_date
183587: and xet.event_class_code = C_EVENT_CLASS_CODE
183588: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 186903: , fnd_lookup_values fvl3

186899: END source_meaning
186900: FROM xla_events_gt xet
186901: , AP_INVOICE_EXTRACT_HEADER_V h2
186902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
186903: , fnd_lookup_values fvl3
186904: , fnd_lookup_values fvl35
186905: , fnd_lookup_values fvl86
186906: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
186907: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 186904: , fnd_lookup_values fvl35

186900: FROM xla_events_gt xet
186901: , AP_INVOICE_EXTRACT_HEADER_V h2
186902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
186903: , fnd_lookup_values fvl3
186904: , fnd_lookup_values fvl35
186905: , fnd_lookup_values fvl86
186906: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
186907: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
186908: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 186905: , fnd_lookup_values fvl86

186901: , AP_INVOICE_EXTRACT_HEADER_V h2
186902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
186903: , fnd_lookup_values fvl3
186904: , fnd_lookup_values fvl35
186905: , fnd_lookup_values fvl86
186906: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
186907: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
186908: AND xet.event_class_code = C_EVENT_CLASS_CODE
186909: AND h2.event_id = xet.event_id

Line 187288: , fnd_lookup_values fvl10

187284: , AP_INVOICE_EXTRACT_DETAILS_V l1
187285: , AP_PO_HEADERS_EXTRACT_V l3
187286: , ZX_AP_DEF_TAX_EXTRACT_V l5
187287: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
187288: , fnd_lookup_values fvl10
187289: , fnd_lookup_values fvl21
187290: , fnd_lookup_values fvl68
187291: , fnd_lookup_values fvl84
187292: , fnd_lookup_values fvl87

Line 187289: , fnd_lookup_values fvl21

187285: , AP_PO_HEADERS_EXTRACT_V l3
187286: , ZX_AP_DEF_TAX_EXTRACT_V l5
187287: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
187288: , fnd_lookup_values fvl10
187289: , fnd_lookup_values fvl21
187290: , fnd_lookup_values fvl68
187291: , fnd_lookup_values fvl84
187292: , fnd_lookup_values fvl87
187293: , fnd_lookup_values fvl135

Line 187290: , fnd_lookup_values fvl68

187286: , ZX_AP_DEF_TAX_EXTRACT_V l5
187287: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
187288: , fnd_lookup_values fvl10
187289: , fnd_lookup_values fvl21
187290: , fnd_lookup_values fvl68
187291: , fnd_lookup_values fvl84
187292: , fnd_lookup_values fvl87
187293: , fnd_lookup_values fvl135
187294: , (select rownum r from all_objects where rownum <= 53 and owner = p_apps_owner)

Line 187291: , fnd_lookup_values fvl84

187287: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
187288: , fnd_lookup_values fvl10
187289: , fnd_lookup_values fvl21
187290: , fnd_lookup_values fvl68
187291: , fnd_lookup_values fvl84
187292: , fnd_lookup_values fvl87
187293: , fnd_lookup_values fvl135
187294: , (select rownum r from all_objects where rownum <= 53 and owner = p_apps_owner)
187295: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 187292: , fnd_lookup_values fvl87

187288: , fnd_lookup_values fvl10
187289: , fnd_lookup_values fvl21
187290: , fnd_lookup_values fvl68
187291: , fnd_lookup_values fvl84
187292: , fnd_lookup_values fvl87
187293: , fnd_lookup_values fvl135
187294: , (select rownum r from all_objects where rownum <= 53 and owner = p_apps_owner)
187295: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
187296: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 187293: , fnd_lookup_values fvl135

187289: , fnd_lookup_values fvl21
187290: , fnd_lookup_values fvl68
187291: , fnd_lookup_values fvl84
187292: , fnd_lookup_values fvl87
187293: , fnd_lookup_values fvl135
187294: , (select rownum r from all_objects where rownum <= 53 and owner = p_apps_owner)
187295: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
187296: AND xet.event_class_code = C_EVENT_CLASS_CODE
187297: AND l1.event_id = xet.event_id

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

187448: l_balance_type_code VARCHAR2(1) :=NULL;
187449: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
187450:
187451: --
187452: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
187453: --
187454:
187455: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
187456: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 187663: , fnd_lookup_values fvl3

187659: , h2.INV_DOC_SEQUENCE_VALUE source_167
187660: FROM xla_events_gt xet
187661: , AP_INVOICE_EXTRACT_HEADER_V h2
187662: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
187663: , fnd_lookup_values fvl3
187664: , fnd_lookup_values fvl35
187665: , fnd_lookup_values fvl86
187666: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
187667: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 187664: , fnd_lookup_values fvl35

187660: FROM xla_events_gt xet
187661: , AP_INVOICE_EXTRACT_HEADER_V h2
187662: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
187663: , fnd_lookup_values fvl3
187664: , fnd_lookup_values fvl35
187665: , fnd_lookup_values fvl86
187666: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
187667: and xet.event_class_code = C_EVENT_CLASS_CODE
187668: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 187665: , fnd_lookup_values fvl86

187661: , AP_INVOICE_EXTRACT_HEADER_V h2
187662: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
187663: , fnd_lookup_values fvl3
187664: , fnd_lookup_values fvl35
187665: , fnd_lookup_values fvl86
187666: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
187667: and xet.event_class_code = C_EVENT_CLASS_CODE
187668: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
187669: AND h4.asp_org_id= h2.ai_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 187780: , fnd_lookup_values fvl10

187776: , AP_INVOICE_EXTRACT_DETAILS_V l1
187777: , AP_PO_HEADERS_EXTRACT_V l3
187778: , ZX_AP_DEF_TAX_EXTRACT_V l5
187779: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
187780: , fnd_lookup_values fvl10
187781: , fnd_lookup_values fvl21
187782: , fnd_lookup_values fvl68
187783: , fnd_lookup_values fvl84
187784: , fnd_lookup_values fvl87

Line 187781: , fnd_lookup_values fvl21

187777: , AP_PO_HEADERS_EXTRACT_V l3
187778: , ZX_AP_DEF_TAX_EXTRACT_V l5
187779: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
187780: , fnd_lookup_values fvl10
187781: , fnd_lookup_values fvl21
187782: , fnd_lookup_values fvl68
187783: , fnd_lookup_values fvl84
187784: , fnd_lookup_values fvl87
187785: , fnd_lookup_values fvl135

Line 187782: , fnd_lookup_values fvl68

187778: , ZX_AP_DEF_TAX_EXTRACT_V l5
187779: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
187780: , fnd_lookup_values fvl10
187781: , fnd_lookup_values fvl21
187782: , fnd_lookup_values fvl68
187783: , fnd_lookup_values fvl84
187784: , fnd_lookup_values fvl87
187785: , fnd_lookup_values fvl135
187786: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 187783: , fnd_lookup_values fvl84

187779: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
187780: , fnd_lookup_values fvl10
187781: , fnd_lookup_values fvl21
187782: , fnd_lookup_values fvl68
187783: , fnd_lookup_values fvl84
187784: , fnd_lookup_values fvl87
187785: , fnd_lookup_values fvl135
187786: WHERE xet.event_id between x_first_event_id and x_last_event_id
187787: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 187784: , fnd_lookup_values fvl87

187780: , fnd_lookup_values fvl10
187781: , fnd_lookup_values fvl21
187782: , fnd_lookup_values fvl68
187783: , fnd_lookup_values fvl84
187784: , fnd_lookup_values fvl87
187785: , fnd_lookup_values fvl135
187786: WHERE xet.event_id between x_first_event_id and x_last_event_id
187787: and xet.event_date between p_pad_start_date and p_pad_end_date
187788: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 187785: , fnd_lookup_values fvl135

187781: , fnd_lookup_values fvl21
187782: , fnd_lookup_values fvl68
187783: , fnd_lookup_values fvl84
187784: , fnd_lookup_values fvl87
187785: , fnd_lookup_values fvl135
187786: WHERE xet.event_id between x_first_event_id and x_last_event_id
187787: and xet.event_date between p_pad_start_date and p_pad_end_date
187788: and xet.event_class_code = C_EVENT_CLASS_CODE
187789: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 191079: , fnd_lookup_values fvl3

191075: END source_meaning
191076: FROM xla_events_gt xet
191077: , AP_PAYMENT_EXTRACT_HEADER_V h2
191078: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
191079: , fnd_lookup_values fvl3
191080: , fnd_lookup_values fvl35
191081: , fnd_lookup_values fvl105
191082: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
191083: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 191080: , fnd_lookup_values fvl35

191076: FROM xla_events_gt xet
191077: , AP_PAYMENT_EXTRACT_HEADER_V h2
191078: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
191079: , fnd_lookup_values fvl3
191080: , fnd_lookup_values fvl35
191081: , fnd_lookup_values fvl105
191082: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
191083: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191084: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 191081: , fnd_lookup_values fvl105

191077: , AP_PAYMENT_EXTRACT_HEADER_V h2
191078: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
191079: , fnd_lookup_values fvl3
191080: , fnd_lookup_values fvl35
191081: , fnd_lookup_values fvl105
191082: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
191083: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191084: AND xet.event_class_code = C_EVENT_CLASS_CODE
191085: AND h2.event_id = xet.event_id

Line 191320: , fnd_lookup_values fvl21

191316: END source_meaning
191317: FROM xla_events_gt xet
191318: , AP_PAYMENT_EXTRACT_DETAILS_V l1
191319: , ZX_AP_DEF_TAX_EXTRACT_V l4
191320: , fnd_lookup_values fvl21
191321: , fnd_lookup_values fvl68
191322: , fnd_lookup_values fvl90
191323: , fnd_lookup_values fvl130
191324: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

Line 191321: , fnd_lookup_values fvl68

191317: FROM xla_events_gt xet
191318: , AP_PAYMENT_EXTRACT_DETAILS_V l1
191319: , ZX_AP_DEF_TAX_EXTRACT_V l4
191320: , fnd_lookup_values fvl21
191321: , fnd_lookup_values fvl68
191322: , fnd_lookup_values fvl90
191323: , fnd_lookup_values fvl130
191324: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
191325: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 191322: , fnd_lookup_values fvl90

191318: , AP_PAYMENT_EXTRACT_DETAILS_V l1
191319: , ZX_AP_DEF_TAX_EXTRACT_V l4
191320: , fnd_lookup_values fvl21
191321: , fnd_lookup_values fvl68
191322: , fnd_lookup_values fvl90
191323: , fnd_lookup_values fvl130
191324: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
191325: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191326: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 191323: , fnd_lookup_values fvl130

191319: , ZX_AP_DEF_TAX_EXTRACT_V l4
191320: , fnd_lookup_values fvl21
191321: , fnd_lookup_values fvl68
191322: , fnd_lookup_values fvl90
191323: , fnd_lookup_values fvl130
191324: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
191325: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191326: AND xet.event_class_code = C_EVENT_CLASS_CODE
191327: AND l1.event_id = xet.event_id

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

191470: l_balance_type_code VARCHAR2(1) :=NULL;
191471: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
191472:
191473: --
191474: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
191475: --
191476:
191477: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
191478: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 191639: , fnd_lookup_values fvl3

191635: , h2.AC_DOC_SEQUENCE_VALUE source_171
191636: FROM xla_events_gt xet
191637: , AP_PAYMENT_EXTRACT_HEADER_V h2
191638: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
191639: , fnd_lookup_values fvl3
191640: , fnd_lookup_values fvl35
191641: , fnd_lookup_values fvl105
191642: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
191643: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 191640: , fnd_lookup_values fvl35

191636: FROM xla_events_gt xet
191637: , AP_PAYMENT_EXTRACT_HEADER_V h2
191638: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
191639: , fnd_lookup_values fvl3
191640: , fnd_lookup_values fvl35
191641: , fnd_lookup_values fvl105
191642: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
191643: and xet.event_class_code = C_EVENT_CLASS_CODE
191644: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 191641: , fnd_lookup_values fvl105

191637: , AP_PAYMENT_EXTRACT_HEADER_V h2
191638: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
191639: , fnd_lookup_values fvl3
191640: , fnd_lookup_values fvl35
191641: , fnd_lookup_values fvl105
191642: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
191643: and xet.event_class_code = C_EVENT_CLASS_CODE
191644: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
191645: AND h3.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 191724: , fnd_lookup_values fvl21

191720: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_156
191721: FROM xla_events_gt xet
191722: , AP_PAYMENT_EXTRACT_DETAILS_V l1
191723: , ZX_AP_DEF_TAX_EXTRACT_V l4
191724: , fnd_lookup_values fvl21
191725: , fnd_lookup_values fvl68
191726: , fnd_lookup_values fvl90
191727: , fnd_lookup_values fvl130
191728: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 191725: , fnd_lookup_values fvl68

191721: FROM xla_events_gt xet
191722: , AP_PAYMENT_EXTRACT_DETAILS_V l1
191723: , ZX_AP_DEF_TAX_EXTRACT_V l4
191724: , fnd_lookup_values fvl21
191725: , fnd_lookup_values fvl68
191726: , fnd_lookup_values fvl90
191727: , fnd_lookup_values fvl130
191728: WHERE xet.event_id between x_first_event_id and x_last_event_id
191729: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 191726: , fnd_lookup_values fvl90

191722: , AP_PAYMENT_EXTRACT_DETAILS_V l1
191723: , ZX_AP_DEF_TAX_EXTRACT_V l4
191724: , fnd_lookup_values fvl21
191725: , fnd_lookup_values fvl68
191726: , fnd_lookup_values fvl90
191727: , fnd_lookup_values fvl130
191728: WHERE xet.event_id between x_first_event_id and x_last_event_id
191729: and xet.event_date between p_pad_start_date and p_pad_end_date
191730: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 191727: , fnd_lookup_values fvl130

191723: , ZX_AP_DEF_TAX_EXTRACT_V l4
191724: , fnd_lookup_values fvl21
191725: , fnd_lookup_values fvl68
191726: , fnd_lookup_values fvl90
191727: , fnd_lookup_values fvl130
191728: WHERE xet.event_id between x_first_event_id and x_last_event_id
191729: and xet.event_date between p_pad_start_date and p_pad_end_date
191730: and xet.event_class_code = C_EVENT_CLASS_CODE
191731: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 193385: , fnd_lookup_values fvl3

193381: END source_meaning
193382: FROM xla_events_gt xet
193383: , AP_INVOICE_EXTRACT_HEADER_V h2
193384: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
193385: , fnd_lookup_values fvl3
193386: , fnd_lookup_values fvl35
193387: , fnd_lookup_values fvl86
193388: , fnd_lookup_values fvl159
193389: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)

Line 193386: , fnd_lookup_values fvl35

193382: FROM xla_events_gt xet
193383: , AP_INVOICE_EXTRACT_HEADER_V h2
193384: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
193385: , fnd_lookup_values fvl3
193386: , fnd_lookup_values fvl35
193387: , fnd_lookup_values fvl86
193388: , fnd_lookup_values fvl159
193389: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
193390: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 193387: , fnd_lookup_values fvl86

193383: , AP_INVOICE_EXTRACT_HEADER_V h2
193384: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
193385: , fnd_lookup_values fvl3
193386: , fnd_lookup_values fvl35
193387: , fnd_lookup_values fvl86
193388: , fnd_lookup_values fvl159
193389: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
193390: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193391: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 193388: , fnd_lookup_values fvl159

193384: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
193385: , fnd_lookup_values fvl3
193386: , fnd_lookup_values fvl35
193387: , fnd_lookup_values fvl86
193388: , fnd_lookup_values fvl159
193389: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
193390: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193391: AND xet.event_class_code = C_EVENT_CLASS_CODE
193392: AND h2.event_id = xet.event_id

Line 193790: , fnd_lookup_values fvl10

193786: , AP_INVOICE_EXTRACT_DETAILS_V l1
193787: , AP_PO_HEADERS_EXTRACT_V l3
193788: , ZX_AP_DEF_TAX_EXTRACT_V l5
193789: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
193790: , fnd_lookup_values fvl10
193791: , fnd_lookup_values fvl21
193792: , fnd_lookup_values fvl68
193793: , fnd_lookup_values fvl84
193794: , fnd_lookup_values fvl87

Line 193791: , fnd_lookup_values fvl21

193787: , AP_PO_HEADERS_EXTRACT_V l3
193788: , ZX_AP_DEF_TAX_EXTRACT_V l5
193789: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
193790: , fnd_lookup_values fvl10
193791: , fnd_lookup_values fvl21
193792: , fnd_lookup_values fvl68
193793: , fnd_lookup_values fvl84
193794: , fnd_lookup_values fvl87
193795: , fnd_lookup_values fvl135

Line 193792: , fnd_lookup_values fvl68

193788: , ZX_AP_DEF_TAX_EXTRACT_V l5
193789: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
193790: , fnd_lookup_values fvl10
193791: , fnd_lookup_values fvl21
193792: , fnd_lookup_values fvl68
193793: , fnd_lookup_values fvl84
193794: , fnd_lookup_values fvl87
193795: , fnd_lookup_values fvl135
193796: , (select rownum r from all_objects where rownum <= 56 and owner = p_apps_owner)

Line 193793: , fnd_lookup_values fvl84

193789: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
193790: , fnd_lookup_values fvl10
193791: , fnd_lookup_values fvl21
193792: , fnd_lookup_values fvl68
193793: , fnd_lookup_values fvl84
193794: , fnd_lookup_values fvl87
193795: , fnd_lookup_values fvl135
193796: , (select rownum r from all_objects where rownum <= 56 and owner = p_apps_owner)
193797: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 193794: , fnd_lookup_values fvl87

193790: , fnd_lookup_values fvl10
193791: , fnd_lookup_values fvl21
193792: , fnd_lookup_values fvl68
193793: , fnd_lookup_values fvl84
193794: , fnd_lookup_values fvl87
193795: , fnd_lookup_values fvl135
193796: , (select rownum r from all_objects where rownum <= 56 and owner = p_apps_owner)
193797: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193798: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 193795: , fnd_lookup_values fvl135

193791: , fnd_lookup_values fvl21
193792: , fnd_lookup_values fvl68
193793: , fnd_lookup_values fvl84
193794: , fnd_lookup_values fvl87
193795: , fnd_lookup_values fvl135
193796: , (select rownum r from all_objects where rownum <= 56 and owner = p_apps_owner)
193797: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193798: AND xet.event_class_code = C_EVENT_CLASS_CODE
193799: AND l1.event_id = xet.event_id

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

193950: l_balance_type_code VARCHAR2(1) :=NULL;
193951: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
193952:
193953: --
193954: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
193955: --
193956:
193957: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
193958: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 194176: , fnd_lookup_values fvl3

194172: , h2.INV_DOC_SEQUENCE_VALUE source_167
194173: FROM xla_events_gt xet
194174: , AP_INVOICE_EXTRACT_HEADER_V h2
194175: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
194176: , fnd_lookup_values fvl3
194177: , fnd_lookup_values fvl35
194178: , fnd_lookup_values fvl86
194179: , fnd_lookup_values fvl159
194180: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 194177: , fnd_lookup_values fvl35

194173: FROM xla_events_gt xet
194174: , AP_INVOICE_EXTRACT_HEADER_V h2
194175: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
194176: , fnd_lookup_values fvl3
194177: , fnd_lookup_values fvl35
194178: , fnd_lookup_values fvl86
194179: , fnd_lookup_values fvl159
194180: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
194181: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 194178: , fnd_lookup_values fvl86

194174: , AP_INVOICE_EXTRACT_HEADER_V h2
194175: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
194176: , fnd_lookup_values fvl3
194177: , fnd_lookup_values fvl35
194178: , fnd_lookup_values fvl86
194179: , fnd_lookup_values fvl159
194180: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
194181: and xet.event_class_code = C_EVENT_CLASS_CODE
194182: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 194179: , fnd_lookup_values fvl159

194175: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
194176: , fnd_lookup_values fvl3
194177: , fnd_lookup_values fvl35
194178: , fnd_lookup_values fvl86
194179: , fnd_lookup_values fvl159
194180: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
194181: and xet.event_class_code = C_EVENT_CLASS_CODE
194182: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
194183: AND h4.asp_org_id = h2.ai_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 194301: , fnd_lookup_values fvl10

194297: , AP_INVOICE_EXTRACT_DETAILS_V l1
194298: , AP_PO_HEADERS_EXTRACT_V l3
194299: , ZX_AP_DEF_TAX_EXTRACT_V l5
194300: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
194301: , fnd_lookup_values fvl10
194302: , fnd_lookup_values fvl21
194303: , fnd_lookup_values fvl68
194304: , fnd_lookup_values fvl84
194305: , fnd_lookup_values fvl87

Line 194302: , fnd_lookup_values fvl21

194298: , AP_PO_HEADERS_EXTRACT_V l3
194299: , ZX_AP_DEF_TAX_EXTRACT_V l5
194300: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
194301: , fnd_lookup_values fvl10
194302: , fnd_lookup_values fvl21
194303: , fnd_lookup_values fvl68
194304: , fnd_lookup_values fvl84
194305: , fnd_lookup_values fvl87
194306: , fnd_lookup_values fvl135

Line 194303: , fnd_lookup_values fvl68

194299: , ZX_AP_DEF_TAX_EXTRACT_V l5
194300: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
194301: , fnd_lookup_values fvl10
194302: , fnd_lookup_values fvl21
194303: , fnd_lookup_values fvl68
194304: , fnd_lookup_values fvl84
194305: , fnd_lookup_values fvl87
194306: , fnd_lookup_values fvl135
194307: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 194304: , fnd_lookup_values fvl84

194300: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
194301: , fnd_lookup_values fvl10
194302: , fnd_lookup_values fvl21
194303: , fnd_lookup_values fvl68
194304: , fnd_lookup_values fvl84
194305: , fnd_lookup_values fvl87
194306: , fnd_lookup_values fvl135
194307: WHERE xet.event_id between x_first_event_id and x_last_event_id
194308: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 194305: , fnd_lookup_values fvl87

194301: , fnd_lookup_values fvl10
194302: , fnd_lookup_values fvl21
194303: , fnd_lookup_values fvl68
194304: , fnd_lookup_values fvl84
194305: , fnd_lookup_values fvl87
194306: , fnd_lookup_values fvl135
194307: WHERE xet.event_id between x_first_event_id and x_last_event_id
194308: and xet.event_date between p_pad_start_date and p_pad_end_date
194309: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 194306: , fnd_lookup_values fvl135

194302: , fnd_lookup_values fvl21
194303: , fnd_lookup_values fvl68
194304: , fnd_lookup_values fvl84
194305: , fnd_lookup_values fvl87
194306: , fnd_lookup_values fvl135
194307: WHERE xet.event_id between x_first_event_id and x_last_event_id
194308: and xet.event_date between p_pad_start_date and p_pad_end_date
194309: and xet.event_class_code = C_EVENT_CLASS_CODE
194310: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

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

197827: l_balance_type_code VARCHAR2(1) :=NULL;
197828: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
197829:
197830: --
197831: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
197832: --
197833:
197834:
197835: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 198909: , fnd_lookup_values fvl3

198905: END source_meaning
198906: FROM xla_events_gt xet
198907: , AP_PAYMENT_EXTRACT_HEADER_V h2
198908: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
198909: , fnd_lookup_values fvl3
198910: , fnd_lookup_values fvl7
198911: , fnd_lookup_values fvl13
198912: , fnd_lookup_values fvl35
198913: , fnd_lookup_values fvl105

Line 198910: , fnd_lookup_values fvl7

198906: FROM xla_events_gt xet
198907: , AP_PAYMENT_EXTRACT_HEADER_V h2
198908: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
198909: , fnd_lookup_values fvl3
198910: , fnd_lookup_values fvl7
198911: , fnd_lookup_values fvl13
198912: , fnd_lookup_values fvl35
198913: , fnd_lookup_values fvl105
198914: , fnd_lookup_values fvl115

Line 198911: , fnd_lookup_values fvl13

198907: , AP_PAYMENT_EXTRACT_HEADER_V h2
198908: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
198909: , fnd_lookup_values fvl3
198910: , fnd_lookup_values fvl7
198911: , fnd_lookup_values fvl13
198912: , fnd_lookup_values fvl35
198913: , fnd_lookup_values fvl105
198914: , fnd_lookup_values fvl115
198915: , fnd_lookup_values fvl185

Line 198912: , fnd_lookup_values fvl35

198908: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
198909: , fnd_lookup_values fvl3
198910: , fnd_lookup_values fvl7
198911: , fnd_lookup_values fvl13
198912: , fnd_lookup_values fvl35
198913: , fnd_lookup_values fvl105
198914: , fnd_lookup_values fvl115
198915: , fnd_lookup_values fvl185
198916: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)

Line 198913: , fnd_lookup_values fvl105

198909: , fnd_lookup_values fvl3
198910: , fnd_lookup_values fvl7
198911: , fnd_lookup_values fvl13
198912: , fnd_lookup_values fvl35
198913: , fnd_lookup_values fvl105
198914: , fnd_lookup_values fvl115
198915: , fnd_lookup_values fvl185
198916: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
198917: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 198914: , fnd_lookup_values fvl115

198910: , fnd_lookup_values fvl7
198911: , fnd_lookup_values fvl13
198912: , fnd_lookup_values fvl35
198913: , fnd_lookup_values fvl105
198914: , fnd_lookup_values fvl115
198915: , fnd_lookup_values fvl185
198916: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
198917: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198918: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 198915: , fnd_lookup_values fvl185

198911: , fnd_lookup_values fvl13
198912: , fnd_lookup_values fvl35
198913: , fnd_lookup_values fvl105
198914: , fnd_lookup_values fvl115
198915: , fnd_lookup_values fvl185
198916: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
198917: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198918: AND xet.event_class_code = C_EVENT_CLASS_CODE
198919: AND h2.event_id = xet.event_id

Line 199218: , fnd_lookup_values fvl21

199214: FROM xla_events_gt xet
199215: , AP_PAYMENT_EXTRACT_DETAILS_V l1
199216: , ZX_AP_DEF_TAX_EXTRACT_V l4
199217: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
199218: , fnd_lookup_values fvl21
199219: , fnd_lookup_values fvl68
199220: , fnd_lookup_values fvl90
199221: , fnd_lookup_values fvl130
199222: , fnd_lookup_values fvl158

Line 199219: , fnd_lookup_values fvl68

199215: , AP_PAYMENT_EXTRACT_DETAILS_V l1
199216: , ZX_AP_DEF_TAX_EXTRACT_V l4
199217: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
199218: , fnd_lookup_values fvl21
199219: , fnd_lookup_values fvl68
199220: , fnd_lookup_values fvl90
199221: , fnd_lookup_values fvl130
199222: , fnd_lookup_values fvl158
199223: , fnd_lookup_values fvl160

Line 199220: , fnd_lookup_values fvl90

199216: , ZX_AP_DEF_TAX_EXTRACT_V l4
199217: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
199218: , fnd_lookup_values fvl21
199219: , fnd_lookup_values fvl68
199220: , fnd_lookup_values fvl90
199221: , fnd_lookup_values fvl130
199222: , fnd_lookup_values fvl158
199223: , fnd_lookup_values fvl160
199224: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)

Line 199221: , fnd_lookup_values fvl130

199217: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
199218: , fnd_lookup_values fvl21
199219: , fnd_lookup_values fvl68
199220: , fnd_lookup_values fvl90
199221: , fnd_lookup_values fvl130
199222: , fnd_lookup_values fvl158
199223: , fnd_lookup_values fvl160
199224: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)
199225: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 199222: , fnd_lookup_values fvl158

199218: , fnd_lookup_values fvl21
199219: , fnd_lookup_values fvl68
199220: , fnd_lookup_values fvl90
199221: , fnd_lookup_values fvl130
199222: , fnd_lookup_values fvl158
199223: , fnd_lookup_values fvl160
199224: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)
199225: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
199226: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 199223: , fnd_lookup_values fvl160

199219: , fnd_lookup_values fvl68
199220: , fnd_lookup_values fvl90
199221: , fnd_lookup_values fvl130
199222: , fnd_lookup_values fvl158
199223: , fnd_lookup_values fvl160
199224: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)
199225: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
199226: AND xet.event_class_code = C_EVENT_CLASS_CODE
199227: AND l1.event_id = xet.event_id

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

199378: l_balance_type_code VARCHAR2(1) :=NULL;
199379: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
199380:
199381: --
199382: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
199383: --
199384:
199385: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
199386: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199614: , fnd_lookup_values fvl3

199610: , fvl185.meaning source_185_meaning
199611: FROM xla_events_gt xet
199612: , AP_PAYMENT_EXTRACT_HEADER_V h2
199613: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
199614: , fnd_lookup_values fvl3
199615: , fnd_lookup_values fvl7
199616: , fnd_lookup_values fvl13
199617: , fnd_lookup_values fvl35
199618: , fnd_lookup_values fvl105

Line 199615: , fnd_lookup_values fvl7

199611: FROM xla_events_gt xet
199612: , AP_PAYMENT_EXTRACT_HEADER_V h2
199613: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
199614: , fnd_lookup_values fvl3
199615: , fnd_lookup_values fvl7
199616: , fnd_lookup_values fvl13
199617: , fnd_lookup_values fvl35
199618: , fnd_lookup_values fvl105
199619: , fnd_lookup_values fvl115

Line 199616: , fnd_lookup_values fvl13

199612: , AP_PAYMENT_EXTRACT_HEADER_V h2
199613: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
199614: , fnd_lookup_values fvl3
199615: , fnd_lookup_values fvl7
199616: , fnd_lookup_values fvl13
199617: , fnd_lookup_values fvl35
199618: , fnd_lookup_values fvl105
199619: , fnd_lookup_values fvl115
199620: , fnd_lookup_values fvl185

Line 199617: , fnd_lookup_values fvl35

199613: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
199614: , fnd_lookup_values fvl3
199615: , fnd_lookup_values fvl7
199616: , fnd_lookup_values fvl13
199617: , fnd_lookup_values fvl35
199618: , fnd_lookup_values fvl105
199619: , fnd_lookup_values fvl115
199620: , fnd_lookup_values fvl185
199621: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 199618: , fnd_lookup_values fvl105

199614: , fnd_lookup_values fvl3
199615: , fnd_lookup_values fvl7
199616: , fnd_lookup_values fvl13
199617: , fnd_lookup_values fvl35
199618: , fnd_lookup_values fvl105
199619: , fnd_lookup_values fvl115
199620: , fnd_lookup_values fvl185
199621: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
199622: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 199619: , fnd_lookup_values fvl115

199615: , fnd_lookup_values fvl7
199616: , fnd_lookup_values fvl13
199617: , fnd_lookup_values fvl35
199618: , fnd_lookup_values fvl105
199619: , fnd_lookup_values fvl115
199620: , fnd_lookup_values fvl185
199621: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
199622: and xet.event_class_code = C_EVENT_CLASS_CODE
199623: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 199620: , fnd_lookup_values fvl185

199616: , fnd_lookup_values fvl13
199617: , fnd_lookup_values fvl35
199618: , fnd_lookup_values fvl105
199619: , fnd_lookup_values fvl115
199620: , fnd_lookup_values fvl185
199621: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
199622: and xet.event_class_code = C_EVENT_CLASS_CODE
199623: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
199624: AND h3.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 199731: , fnd_lookup_values fvl21

199727: FROM xla_events_gt xet
199728: , AP_PAYMENT_EXTRACT_DETAILS_V l1
199729: , ZX_AP_DEF_TAX_EXTRACT_V l4
199730: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
199731: , fnd_lookup_values fvl21
199732: , fnd_lookup_values fvl68
199733: , fnd_lookup_values fvl90
199734: , fnd_lookup_values fvl130
199735: , fnd_lookup_values fvl158

Line 199732: , fnd_lookup_values fvl68

199728: , AP_PAYMENT_EXTRACT_DETAILS_V l1
199729: , ZX_AP_DEF_TAX_EXTRACT_V l4
199730: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
199731: , fnd_lookup_values fvl21
199732: , fnd_lookup_values fvl68
199733: , fnd_lookup_values fvl90
199734: , fnd_lookup_values fvl130
199735: , fnd_lookup_values fvl158
199736: , fnd_lookup_values fvl160

Line 199733: , fnd_lookup_values fvl90

199729: , ZX_AP_DEF_TAX_EXTRACT_V l4
199730: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
199731: , fnd_lookup_values fvl21
199732: , fnd_lookup_values fvl68
199733: , fnd_lookup_values fvl90
199734: , fnd_lookup_values fvl130
199735: , fnd_lookup_values fvl158
199736: , fnd_lookup_values fvl160
199737: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 199734: , fnd_lookup_values fvl130

199730: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
199731: , fnd_lookup_values fvl21
199732: , fnd_lookup_values fvl68
199733: , fnd_lookup_values fvl90
199734: , fnd_lookup_values fvl130
199735: , fnd_lookup_values fvl158
199736: , fnd_lookup_values fvl160
199737: WHERE xet.event_id between x_first_event_id and x_last_event_id
199738: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 199735: , fnd_lookup_values fvl158

199731: , fnd_lookup_values fvl21
199732: , fnd_lookup_values fvl68
199733: , fnd_lookup_values fvl90
199734: , fnd_lookup_values fvl130
199735: , fnd_lookup_values fvl158
199736: , fnd_lookup_values fvl160
199737: WHERE xet.event_id between x_first_event_id and x_last_event_id
199738: and xet.event_date between p_pad_start_date and p_pad_end_date
199739: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 199736: , fnd_lookup_values fvl160

199732: , fnd_lookup_values fvl68
199733: , fnd_lookup_values fvl90
199734: , fnd_lookup_values fvl130
199735: , fnd_lookup_values fvl158
199736: , fnd_lookup_values fvl160
199737: WHERE xet.event_id between x_first_event_id and x_last_event_id
199738: and xet.event_date between p_pad_start_date and p_pad_end_date
199739: and xet.event_class_code = C_EVENT_CLASS_CODE
199740: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 201918: , fnd_lookup_values fvl3

201914: END source_meaning
201915: FROM xla_events_gt xet
201916: , AP_INVOICE_EXTRACT_HEADER_V h1
201917: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
201918: , fnd_lookup_values fvl3
201919: , fnd_lookup_values fvl86
201920: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
201921: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
201922: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 201919: , fnd_lookup_values fvl86

201915: FROM xla_events_gt xet
201916: , AP_INVOICE_EXTRACT_HEADER_V h1
201917: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
201918: , fnd_lookup_values fvl3
201919: , fnd_lookup_values fvl86
201920: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
201921: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
201922: AND xet.event_class_code = C_EVENT_CLASS_CODE
201923: AND h1.event_id = xet.event_id

Line 202276: , fnd_lookup_values fvl68

202272: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
202273: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
202274: , ZX_AP_DEF_TAX_EXTRACT_V l5
202275: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
202276: , fnd_lookup_values fvl68
202277: , fnd_lookup_values fvl87
202278: , fnd_lookup_values fvl119
202279: , fnd_lookup_values fvl130
202280: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)

Line 202277: , fnd_lookup_values fvl87

202273: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
202274: , ZX_AP_DEF_TAX_EXTRACT_V l5
202275: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
202276: , fnd_lookup_values fvl68
202277: , fnd_lookup_values fvl87
202278: , fnd_lookup_values fvl119
202279: , fnd_lookup_values fvl130
202280: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
202281: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 202278: , fnd_lookup_values fvl119

202274: , ZX_AP_DEF_TAX_EXTRACT_V l5
202275: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
202276: , fnd_lookup_values fvl68
202277: , fnd_lookup_values fvl87
202278: , fnd_lookup_values fvl119
202279: , fnd_lookup_values fvl130
202280: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
202281: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
202282: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 202279: , fnd_lookup_values fvl130

202275: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
202276: , fnd_lookup_values fvl68
202277: , fnd_lookup_values fvl87
202278: , fnd_lookup_values fvl119
202279: , fnd_lookup_values fvl130
202280: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
202281: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
202282: AND xet.event_class_code = C_EVENT_CLASS_CODE
202283: AND l2.event_id = xet.event_id

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

202426: l_balance_type_code VARCHAR2(1) :=NULL;
202427: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
202428:
202429: --
202430: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
202431: --
202432:
202433: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
202434: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 202626: , fnd_lookup_values fvl3

202622: , h1.INV_DOC_SEQUENCE_VALUE source_167
202623: FROM xla_events_gt xet
202624: , AP_INVOICE_EXTRACT_HEADER_V h1
202625: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
202626: , fnd_lookup_values fvl3
202627: , fnd_lookup_values fvl86
202628: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
202629: and xet.event_class_code = C_EVENT_CLASS_CODE
202630: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 202627: , fnd_lookup_values fvl86

202623: FROM xla_events_gt xet
202624: , AP_INVOICE_EXTRACT_HEADER_V h1
202625: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
202626: , fnd_lookup_values fvl3
202627: , fnd_lookup_values fvl86
202628: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
202629: and xet.event_class_code = C_EVENT_CLASS_CODE
202630: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
202631: AND h4.asp_org_id = h1.ai_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 202732: , fnd_lookup_values fvl68

202728: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
202729: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
202730: , ZX_AP_DEF_TAX_EXTRACT_V l5
202731: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
202732: , fnd_lookup_values fvl68
202733: , fnd_lookup_values fvl87
202734: , fnd_lookup_values fvl119
202735: , fnd_lookup_values fvl130
202736: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 202733: , fnd_lookup_values fvl87

202729: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
202730: , ZX_AP_DEF_TAX_EXTRACT_V l5
202731: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
202732: , fnd_lookup_values fvl68
202733: , fnd_lookup_values fvl87
202734: , fnd_lookup_values fvl119
202735: , fnd_lookup_values fvl130
202736: WHERE xet.event_id between x_first_event_id and x_last_event_id
202737: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 202734: , fnd_lookup_values fvl119

202730: , ZX_AP_DEF_TAX_EXTRACT_V l5
202731: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
202732: , fnd_lookup_values fvl68
202733: , fnd_lookup_values fvl87
202734: , fnd_lookup_values fvl119
202735: , fnd_lookup_values fvl130
202736: WHERE xet.event_id between x_first_event_id and x_last_event_id
202737: and xet.event_date between p_pad_start_date and p_pad_end_date
202738: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 202735: , fnd_lookup_values fvl130

202731: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
202732: , fnd_lookup_values fvl68
202733: , fnd_lookup_values fvl87
202734: , fnd_lookup_values fvl119
202735: , fnd_lookup_values fvl130
202736: WHERE xet.event_id between x_first_event_id and x_last_event_id
202737: and xet.event_date between p_pad_start_date and p_pad_end_date
202738: and xet.event_class_code = C_EVENT_CLASS_CODE
202739: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 204402: , fnd_lookup_values fvl3

204398: END source_meaning
204399: FROM xla_events_gt xet
204400: , AP_INVOICE_EXTRACT_HEADER_V h2
204401: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
204402: , fnd_lookup_values fvl3
204403: , fnd_lookup_values fvl19
204404: , fnd_lookup_values fvl35
204405: , fnd_lookup_values fvl86
204406: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)

Line 204403: , fnd_lookup_values fvl19

204399: FROM xla_events_gt xet
204400: , AP_INVOICE_EXTRACT_HEADER_V h2
204401: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
204402: , fnd_lookup_values fvl3
204403: , fnd_lookup_values fvl19
204404: , fnd_lookup_values fvl35
204405: , fnd_lookup_values fvl86
204406: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
204407: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 204404: , fnd_lookup_values fvl35

204400: , AP_INVOICE_EXTRACT_HEADER_V h2
204401: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
204402: , fnd_lookup_values fvl3
204403: , fnd_lookup_values fvl19
204404: , fnd_lookup_values fvl35
204405: , fnd_lookup_values fvl86
204406: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
204407: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204408: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 204405: , fnd_lookup_values fvl86

204401: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
204402: , fnd_lookup_values fvl3
204403: , fnd_lookup_values fvl19
204404: , fnd_lookup_values fvl35
204405: , fnd_lookup_values fvl86
204406: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
204407: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204408: AND xet.event_class_code = C_EVENT_CLASS_CODE
204409: AND h2.event_id = xet.event_id

Line 204783: , fnd_lookup_values fvl10

204779: , AP_INVOICE_EXTRACT_DETAILS_V l1
204780: , AP_PO_HEADERS_EXTRACT_V l3
204781: , ZX_AP_DEF_TAX_EXTRACT_V l5
204782: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
204783: , fnd_lookup_values fvl10
204784: , fnd_lookup_values fvl21
204785: , fnd_lookup_values fvl68
204786: , fnd_lookup_values fvl84
204787: , fnd_lookup_values fvl87

Line 204784: , fnd_lookup_values fvl21

204780: , AP_PO_HEADERS_EXTRACT_V l3
204781: , ZX_AP_DEF_TAX_EXTRACT_V l5
204782: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
204783: , fnd_lookup_values fvl10
204784: , fnd_lookup_values fvl21
204785: , fnd_lookup_values fvl68
204786: , fnd_lookup_values fvl84
204787: , fnd_lookup_values fvl87
204788: , fnd_lookup_values fvl130

Line 204785: , fnd_lookup_values fvl68

204781: , ZX_AP_DEF_TAX_EXTRACT_V l5
204782: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
204783: , fnd_lookup_values fvl10
204784: , fnd_lookup_values fvl21
204785: , fnd_lookup_values fvl68
204786: , fnd_lookup_values fvl84
204787: , fnd_lookup_values fvl87
204788: , fnd_lookup_values fvl130
204789: , fnd_lookup_values fvl135

Line 204786: , fnd_lookup_values fvl84

204782: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
204783: , fnd_lookup_values fvl10
204784: , fnd_lookup_values fvl21
204785: , fnd_lookup_values fvl68
204786: , fnd_lookup_values fvl84
204787: , fnd_lookup_values fvl87
204788: , fnd_lookup_values fvl130
204789: , fnd_lookup_values fvl135
204790: , (select rownum r from all_objects where rownum <= 51 and owner = p_apps_owner)

Line 204787: , fnd_lookup_values fvl87

204783: , fnd_lookup_values fvl10
204784: , fnd_lookup_values fvl21
204785: , fnd_lookup_values fvl68
204786: , fnd_lookup_values fvl84
204787: , fnd_lookup_values fvl87
204788: , fnd_lookup_values fvl130
204789: , fnd_lookup_values fvl135
204790: , (select rownum r from all_objects where rownum <= 51 and owner = p_apps_owner)
204791: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 204788: , fnd_lookup_values fvl130

204784: , fnd_lookup_values fvl21
204785: , fnd_lookup_values fvl68
204786: , fnd_lookup_values fvl84
204787: , fnd_lookup_values fvl87
204788: , fnd_lookup_values fvl130
204789: , fnd_lookup_values fvl135
204790: , (select rownum r from all_objects where rownum <= 51 and owner = p_apps_owner)
204791: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204792: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 204789: , fnd_lookup_values fvl135

204785: , fnd_lookup_values fvl68
204786: , fnd_lookup_values fvl84
204787: , fnd_lookup_values fvl87
204788: , fnd_lookup_values fvl130
204789: , fnd_lookup_values fvl135
204790: , (select rownum r from all_objects where rownum <= 51 and owner = p_apps_owner)
204791: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204792: AND xet.event_class_code = C_EVENT_CLASS_CODE
204793: AND l1.event_id = xet.event_id

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

204948: l_balance_type_code VARCHAR2(1) :=NULL;
204949: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
204950:
204951: --
204952: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
204953: --
204954:
204955: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
204956: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 205162: , fnd_lookup_values fvl3

205158: , h2.INV_DOC_SEQUENCE_VALUE source_167
205159: FROM xla_events_gt xet
205160: , AP_INVOICE_EXTRACT_HEADER_V h2
205161: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
205162: , fnd_lookup_values fvl3
205163: , fnd_lookup_values fvl19
205164: , fnd_lookup_values fvl35
205165: , fnd_lookup_values fvl86
205166: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 205163: , fnd_lookup_values fvl19

205159: FROM xla_events_gt xet
205160: , AP_INVOICE_EXTRACT_HEADER_V h2
205161: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
205162: , fnd_lookup_values fvl3
205163: , fnd_lookup_values fvl19
205164: , fnd_lookup_values fvl35
205165: , fnd_lookup_values fvl86
205166: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
205167: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 205164: , fnd_lookup_values fvl35

205160: , AP_INVOICE_EXTRACT_HEADER_V h2
205161: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
205162: , fnd_lookup_values fvl3
205163: , fnd_lookup_values fvl19
205164: , fnd_lookup_values fvl35
205165: , fnd_lookup_values fvl86
205166: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
205167: and xet.event_class_code = C_EVENT_CLASS_CODE
205168: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 205165: , fnd_lookup_values fvl86

205161: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
205162: , fnd_lookup_values fvl3
205163: , fnd_lookup_values fvl19
205164: , fnd_lookup_values fvl35
205165: , fnd_lookup_values fvl86
205166: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
205167: and xet.event_class_code = C_EVENT_CLASS_CODE
205168: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
205169: AND h4.asp_org_id = h2.ai_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 205283: , fnd_lookup_values fvl10

205279: , AP_INVOICE_EXTRACT_DETAILS_V l1
205280: , AP_PO_HEADERS_EXTRACT_V l3
205281: , ZX_AP_DEF_TAX_EXTRACT_V l5
205282: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
205283: , fnd_lookup_values fvl10
205284: , fnd_lookup_values fvl21
205285: , fnd_lookup_values fvl68
205286: , fnd_lookup_values fvl84
205287: , fnd_lookup_values fvl87

Line 205284: , fnd_lookup_values fvl21

205280: , AP_PO_HEADERS_EXTRACT_V l3
205281: , ZX_AP_DEF_TAX_EXTRACT_V l5
205282: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
205283: , fnd_lookup_values fvl10
205284: , fnd_lookup_values fvl21
205285: , fnd_lookup_values fvl68
205286: , fnd_lookup_values fvl84
205287: , fnd_lookup_values fvl87
205288: , fnd_lookup_values fvl130

Line 205285: , fnd_lookup_values fvl68

205281: , ZX_AP_DEF_TAX_EXTRACT_V l5
205282: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
205283: , fnd_lookup_values fvl10
205284: , fnd_lookup_values fvl21
205285: , fnd_lookup_values fvl68
205286: , fnd_lookup_values fvl84
205287: , fnd_lookup_values fvl87
205288: , fnd_lookup_values fvl130
205289: , fnd_lookup_values fvl135

Line 205286: , fnd_lookup_values fvl84

205282: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
205283: , fnd_lookup_values fvl10
205284: , fnd_lookup_values fvl21
205285: , fnd_lookup_values fvl68
205286: , fnd_lookup_values fvl84
205287: , fnd_lookup_values fvl87
205288: , fnd_lookup_values fvl130
205289: , fnd_lookup_values fvl135
205290: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 205287: , fnd_lookup_values fvl87

205283: , fnd_lookup_values fvl10
205284: , fnd_lookup_values fvl21
205285: , fnd_lookup_values fvl68
205286: , fnd_lookup_values fvl84
205287: , fnd_lookup_values fvl87
205288: , fnd_lookup_values fvl130
205289: , fnd_lookup_values fvl135
205290: WHERE xet.event_id between x_first_event_id and x_last_event_id
205291: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 205288: , fnd_lookup_values fvl130

205284: , fnd_lookup_values fvl21
205285: , fnd_lookup_values fvl68
205286: , fnd_lookup_values fvl84
205287: , fnd_lookup_values fvl87
205288: , fnd_lookup_values fvl130
205289: , fnd_lookup_values fvl135
205290: WHERE xet.event_id between x_first_event_id and x_last_event_id
205291: and xet.event_date between p_pad_start_date and p_pad_end_date
205292: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 205289: , fnd_lookup_values fvl135

205285: , fnd_lookup_values fvl68
205286: , fnd_lookup_values fvl84
205287: , fnd_lookup_values fvl87
205288: , fnd_lookup_values fvl130
205289: , fnd_lookup_values fvl135
205290: WHERE xet.event_id between x_first_event_id and x_last_event_id
205291: and xet.event_date between p_pad_start_date and p_pad_end_date
205292: and xet.event_class_code = C_EVENT_CLASS_CODE
205293: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

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

208731: l_balance_type_code VARCHAR2(1) :=NULL;
208732: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
208733:
208734: --
208735: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
208736: --
208737:
208738:
208739: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

209843: l_balance_type_code VARCHAR2(1) :=NULL;
209844: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
209845:
209846: --
209847: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
209848: --
209849:
209850:
209851: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 210913: , fnd_lookup_values fvl3

210909: END source_meaning
210910: FROM xla_events_gt xet
210911: , AP_PAYMENT_EXTRACT_HEADER_V h2
210912: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
210913: , fnd_lookup_values fvl3
210914: , fnd_lookup_values fvl7
210915: , fnd_lookup_values fvl35
210916: , fnd_lookup_values fvl105
210917: , fnd_lookup_values fvl115

Line 210914: , fnd_lookup_values fvl7

210910: FROM xla_events_gt xet
210911: , AP_PAYMENT_EXTRACT_HEADER_V h2
210912: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
210913: , fnd_lookup_values fvl3
210914: , fnd_lookup_values fvl7
210915: , fnd_lookup_values fvl35
210916: , fnd_lookup_values fvl105
210917: , fnd_lookup_values fvl115
210918: ,(select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)

Line 210915: , fnd_lookup_values fvl35

210911: , AP_PAYMENT_EXTRACT_HEADER_V h2
210912: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
210913: , fnd_lookup_values fvl3
210914: , fnd_lookup_values fvl7
210915: , fnd_lookup_values fvl35
210916: , fnd_lookup_values fvl105
210917: , fnd_lookup_values fvl115
210918: ,(select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)
210919: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 210916: , fnd_lookup_values fvl105

210912: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
210913: , fnd_lookup_values fvl3
210914: , fnd_lookup_values fvl7
210915: , fnd_lookup_values fvl35
210916: , fnd_lookup_values fvl105
210917: , fnd_lookup_values fvl115
210918: ,(select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)
210919: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
210920: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 210917: , fnd_lookup_values fvl115

210913: , fnd_lookup_values fvl3
210914: , fnd_lookup_values fvl7
210915: , fnd_lookup_values fvl35
210916: , fnd_lookup_values fvl105
210917: , fnd_lookup_values fvl115
210918: ,(select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)
210919: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
210920: AND xet.event_class_code = C_EVENT_CLASS_CODE
210921: AND h2.event_id = xet.event_id

Line 211251: , fnd_lookup_values fvl21

211247: END source_meaning
211248: FROM xla_events_gt xet
211249: , AP_PAYMENT_EXTRACT_DETAILS_V l1
211250: , ZX_AP_DEF_TAX_EXTRACT_V l4
211251: , fnd_lookup_values fvl21
211252: , fnd_lookup_values fvl68
211253: , fnd_lookup_values fvl90
211254: , fnd_lookup_values fvl130
211255: , fnd_lookup_values fvl158

Line 211252: , fnd_lookup_values fvl68

211248: FROM xla_events_gt xet
211249: , AP_PAYMENT_EXTRACT_DETAILS_V l1
211250: , ZX_AP_DEF_TAX_EXTRACT_V l4
211251: , fnd_lookup_values fvl21
211252: , fnd_lookup_values fvl68
211253: , fnd_lookup_values fvl90
211254: , fnd_lookup_values fvl130
211255: , fnd_lookup_values fvl158
211256: , fnd_lookup_values fvl160

Line 211253: , fnd_lookup_values fvl90

211249: , AP_PAYMENT_EXTRACT_DETAILS_V l1
211250: , ZX_AP_DEF_TAX_EXTRACT_V l4
211251: , fnd_lookup_values fvl21
211252: , fnd_lookup_values fvl68
211253: , fnd_lookup_values fvl90
211254: , fnd_lookup_values fvl130
211255: , fnd_lookup_values fvl158
211256: , fnd_lookup_values fvl160
211257: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)

Line 211254: , fnd_lookup_values fvl130

211250: , ZX_AP_DEF_TAX_EXTRACT_V l4
211251: , fnd_lookup_values fvl21
211252: , fnd_lookup_values fvl68
211253: , fnd_lookup_values fvl90
211254: , fnd_lookup_values fvl130
211255: , fnd_lookup_values fvl158
211256: , fnd_lookup_values fvl160
211257: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
211258: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 211255: , fnd_lookup_values fvl158

211251: , fnd_lookup_values fvl21
211252: , fnd_lookup_values fvl68
211253: , fnd_lookup_values fvl90
211254: , fnd_lookup_values fvl130
211255: , fnd_lookup_values fvl158
211256: , fnd_lookup_values fvl160
211257: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
211258: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
211259: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 211256: , fnd_lookup_values fvl160

211252: , fnd_lookup_values fvl68
211253: , fnd_lookup_values fvl90
211254: , fnd_lookup_values fvl130
211255: , fnd_lookup_values fvl158
211256: , fnd_lookup_values fvl160
211257: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
211258: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
211259: AND xet.event_class_code = C_EVENT_CLASS_CODE
211260: AND l1.event_id = xet.event_id

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

211411: l_balance_type_code VARCHAR2(1) :=NULL;
211412: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
211413:
211414: --
211415: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
211416: --
211417:
211418: TYPE t_array_source_2 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
211419: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 211653: , fnd_lookup_values fvl3

211649: , h2.AC_DOC_SEQUENCE_VALUE source_171
211650: FROM xla_events_gt xet
211651: , AP_PAYMENT_EXTRACT_HEADER_V h2
211652: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
211653: , fnd_lookup_values fvl3
211654: , fnd_lookup_values fvl7
211655: , fnd_lookup_values fvl35
211656: , fnd_lookup_values fvl105
211657: , fnd_lookup_values fvl115

Line 211654: , fnd_lookup_values fvl7

211650: FROM xla_events_gt xet
211651: , AP_PAYMENT_EXTRACT_HEADER_V h2
211652: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
211653: , fnd_lookup_values fvl3
211654: , fnd_lookup_values fvl7
211655: , fnd_lookup_values fvl35
211656: , fnd_lookup_values fvl105
211657: , fnd_lookup_values fvl115
211658: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 211655: , fnd_lookup_values fvl35

211651: , AP_PAYMENT_EXTRACT_HEADER_V h2
211652: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
211653: , fnd_lookup_values fvl3
211654: , fnd_lookup_values fvl7
211655: , fnd_lookup_values fvl35
211656: , fnd_lookup_values fvl105
211657: , fnd_lookup_values fvl115
211658: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
211659: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 211656: , fnd_lookup_values fvl105

211652: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
211653: , fnd_lookup_values fvl3
211654: , fnd_lookup_values fvl7
211655: , fnd_lookup_values fvl35
211656: , fnd_lookup_values fvl105
211657: , fnd_lookup_values fvl115
211658: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
211659: and xet.event_class_code = C_EVENT_CLASS_CODE
211660: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 211657: , fnd_lookup_values fvl115

211653: , fnd_lookup_values fvl3
211654: , fnd_lookup_values fvl7
211655: , fnd_lookup_values fvl35
211656: , fnd_lookup_values fvl105
211657: , fnd_lookup_values fvl115
211658: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
211659: and xet.event_class_code = C_EVENT_CLASS_CODE
211660: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
211661: AND h3.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 211767: , fnd_lookup_values fvl21

211763: , fvl160.meaning source_160_meaning
211764: FROM xla_events_gt xet
211765: , AP_PAYMENT_EXTRACT_DETAILS_V l1
211766: , ZX_AP_DEF_TAX_EXTRACT_V l4
211767: , fnd_lookup_values fvl21
211768: , fnd_lookup_values fvl68
211769: , fnd_lookup_values fvl90
211770: , fnd_lookup_values fvl130
211771: , fnd_lookup_values fvl158

Line 211768: , fnd_lookup_values fvl68

211764: FROM xla_events_gt xet
211765: , AP_PAYMENT_EXTRACT_DETAILS_V l1
211766: , ZX_AP_DEF_TAX_EXTRACT_V l4
211767: , fnd_lookup_values fvl21
211768: , fnd_lookup_values fvl68
211769: , fnd_lookup_values fvl90
211770: , fnd_lookup_values fvl130
211771: , fnd_lookup_values fvl158
211772: , fnd_lookup_values fvl160

Line 211769: , fnd_lookup_values fvl90

211765: , AP_PAYMENT_EXTRACT_DETAILS_V l1
211766: , ZX_AP_DEF_TAX_EXTRACT_V l4
211767: , fnd_lookup_values fvl21
211768: , fnd_lookup_values fvl68
211769: , fnd_lookup_values fvl90
211770: , fnd_lookup_values fvl130
211771: , fnd_lookup_values fvl158
211772: , fnd_lookup_values fvl160
211773: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 211770: , fnd_lookup_values fvl130

211766: , ZX_AP_DEF_TAX_EXTRACT_V l4
211767: , fnd_lookup_values fvl21
211768: , fnd_lookup_values fvl68
211769: , fnd_lookup_values fvl90
211770: , fnd_lookup_values fvl130
211771: , fnd_lookup_values fvl158
211772: , fnd_lookup_values fvl160
211773: WHERE xet.event_id between x_first_event_id and x_last_event_id
211774: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 211771: , fnd_lookup_values fvl158

211767: , fnd_lookup_values fvl21
211768: , fnd_lookup_values fvl68
211769: , fnd_lookup_values fvl90
211770: , fnd_lookup_values fvl130
211771: , fnd_lookup_values fvl158
211772: , fnd_lookup_values fvl160
211773: WHERE xet.event_id between x_first_event_id and x_last_event_id
211774: and xet.event_date between p_pad_start_date and p_pad_end_date
211775: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 211772: , fnd_lookup_values fvl160

211768: , fnd_lookup_values fvl68
211769: , fnd_lookup_values fvl90
211770: , fnd_lookup_values fvl130
211771: , fnd_lookup_values fvl158
211772: , fnd_lookup_values fvl160
211773: WHERE xet.event_id between x_first_event_id and x_last_event_id
211774: and xet.event_date between p_pad_start_date and p_pad_end_date
211775: and xet.event_class_code = C_EVENT_CLASS_CODE
211776: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 213974: , fnd_lookup_values fvl3

213970: END source_meaning
213971: FROM xla_events_gt xet
213972: , AP_PAYMENT_EXTRACT_HEADER_V h2
213973: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
213974: , fnd_lookup_values fvl3
213975: , fnd_lookup_values fvl7
213976: , fnd_lookup_values fvl35
213977: , fnd_lookup_values fvl105
213978: , fnd_lookup_values fvl115

Line 213975: , fnd_lookup_values fvl7

213971: FROM xla_events_gt xet
213972: , AP_PAYMENT_EXTRACT_HEADER_V h2
213973: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
213974: , fnd_lookup_values fvl3
213975: , fnd_lookup_values fvl7
213976: , fnd_lookup_values fvl35
213977: , fnd_lookup_values fvl105
213978: , fnd_lookup_values fvl115
213979: , fnd_lookup_values fvl185

Line 213976: , fnd_lookup_values fvl35

213972: , AP_PAYMENT_EXTRACT_HEADER_V h2
213973: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
213974: , fnd_lookup_values fvl3
213975: , fnd_lookup_values fvl7
213976: , fnd_lookup_values fvl35
213977: , fnd_lookup_values fvl105
213978: , fnd_lookup_values fvl115
213979: , fnd_lookup_values fvl185
213980: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)

Line 213977: , fnd_lookup_values fvl105

213973: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
213974: , fnd_lookup_values fvl3
213975: , fnd_lookup_values fvl7
213976: , fnd_lookup_values fvl35
213977: , fnd_lookup_values fvl105
213978: , fnd_lookup_values fvl115
213979: , fnd_lookup_values fvl185
213980: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
213981: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 213978: , fnd_lookup_values fvl115

213974: , fnd_lookup_values fvl3
213975: , fnd_lookup_values fvl7
213976: , fnd_lookup_values fvl35
213977: , fnd_lookup_values fvl105
213978: , fnd_lookup_values fvl115
213979: , fnd_lookup_values fvl185
213980: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
213981: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
213982: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 213979: , fnd_lookup_values fvl185

213975: , fnd_lookup_values fvl7
213976: , fnd_lookup_values fvl35
213977: , fnd_lookup_values fvl105
213978: , fnd_lookup_values fvl115
213979: , fnd_lookup_values fvl185
213980: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
213981: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
213982: AND xet.event_class_code = C_EVENT_CLASS_CODE
213983: AND h2.event_id = xet.event_id

Line 214240: , fnd_lookup_values fvl21

214236: FROM xla_events_gt xet
214237: , AP_PAYMENT_EXTRACT_DETAILS_V l1
214238: , ZX_AP_DEF_TAX_EXTRACT_V l4
214239: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
214240: , fnd_lookup_values fvl21
214241: , fnd_lookup_values fvl68
214242: , fnd_lookup_values fvl90
214243: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
214244: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 214241: , fnd_lookup_values fvl68

214237: , AP_PAYMENT_EXTRACT_DETAILS_V l1
214238: , ZX_AP_DEF_TAX_EXTRACT_V l4
214239: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
214240: , fnd_lookup_values fvl21
214241: , fnd_lookup_values fvl68
214242: , fnd_lookup_values fvl90
214243: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
214244: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
214245: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 214242: , fnd_lookup_values fvl90

214238: , ZX_AP_DEF_TAX_EXTRACT_V l4
214239: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
214240: , fnd_lookup_values fvl21
214241: , fnd_lookup_values fvl68
214242: , fnd_lookup_values fvl90
214243: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
214244: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
214245: AND xet.event_class_code = C_EVENT_CLASS_CODE
214246: AND l1.event_id = xet.event_id

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

214385: l_balance_type_code VARCHAR2(1) :=NULL;
214386: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
214387:
214388: --
214389: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
214390: --
214391:
214392: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
214393: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 214578: , fnd_lookup_values fvl3

214574: , fvl185.meaning source_185_meaning
214575: FROM xla_events_gt xet
214576: , AP_PAYMENT_EXTRACT_HEADER_V h2
214577: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
214578: , fnd_lookup_values fvl3
214579: , fnd_lookup_values fvl7
214580: , fnd_lookup_values fvl35
214581: , fnd_lookup_values fvl105
214582: , fnd_lookup_values fvl115

Line 214579: , fnd_lookup_values fvl7

214575: FROM xla_events_gt xet
214576: , AP_PAYMENT_EXTRACT_HEADER_V h2
214577: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
214578: , fnd_lookup_values fvl3
214579: , fnd_lookup_values fvl7
214580: , fnd_lookup_values fvl35
214581: , fnd_lookup_values fvl105
214582: , fnd_lookup_values fvl115
214583: , fnd_lookup_values fvl185

Line 214580: , fnd_lookup_values fvl35

214576: , AP_PAYMENT_EXTRACT_HEADER_V h2
214577: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
214578: , fnd_lookup_values fvl3
214579: , fnd_lookup_values fvl7
214580: , fnd_lookup_values fvl35
214581: , fnd_lookup_values fvl105
214582: , fnd_lookup_values fvl115
214583: , fnd_lookup_values fvl185
214584: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 214581: , fnd_lookup_values fvl105

214577: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
214578: , fnd_lookup_values fvl3
214579: , fnd_lookup_values fvl7
214580: , fnd_lookup_values fvl35
214581: , fnd_lookup_values fvl105
214582: , fnd_lookup_values fvl115
214583: , fnd_lookup_values fvl185
214584: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
214585: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 214582: , fnd_lookup_values fvl115

214578: , fnd_lookup_values fvl3
214579: , fnd_lookup_values fvl7
214580: , fnd_lookup_values fvl35
214581: , fnd_lookup_values fvl105
214582: , fnd_lookup_values fvl115
214583: , fnd_lookup_values fvl185
214584: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
214585: and xet.event_class_code = C_EVENT_CLASS_CODE
214586: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 214583: , fnd_lookup_values fvl185

214579: , fnd_lookup_values fvl7
214580: , fnd_lookup_values fvl35
214581: , fnd_lookup_values fvl105
214582: , fnd_lookup_values fvl115
214583: , fnd_lookup_values fvl185
214584: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
214585: and xet.event_class_code = C_EVENT_CLASS_CODE
214586: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
214587: AND h3.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 214680: , fnd_lookup_values fvl21

214676: FROM xla_events_gt xet
214677: , AP_PAYMENT_EXTRACT_DETAILS_V l1
214678: , ZX_AP_DEF_TAX_EXTRACT_V l4
214679: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
214680: , fnd_lookup_values fvl21
214681: , fnd_lookup_values fvl68
214682: , fnd_lookup_values fvl90
214683: WHERE xet.event_id between x_first_event_id and x_last_event_id
214684: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 214681: , fnd_lookup_values fvl68

214677: , AP_PAYMENT_EXTRACT_DETAILS_V l1
214678: , ZX_AP_DEF_TAX_EXTRACT_V l4
214679: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
214680: , fnd_lookup_values fvl21
214681: , fnd_lookup_values fvl68
214682: , fnd_lookup_values fvl90
214683: WHERE xet.event_id between x_first_event_id and x_last_event_id
214684: and xet.event_date between p_pad_start_date and p_pad_end_date
214685: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 214682: , fnd_lookup_values fvl90

214678: , ZX_AP_DEF_TAX_EXTRACT_V l4
214679: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
214680: , fnd_lookup_values fvl21
214681: , fnd_lookup_values fvl68
214682: , fnd_lookup_values fvl90
214683: WHERE xet.event_id between x_first_event_id and x_last_event_id
214684: and xet.event_date between p_pad_start_date and p_pad_end_date
214685: and xet.event_class_code = C_EVENT_CLASS_CODE
214686: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id