DBA Data[Home] [Help]

APPS.XLA_00200_AAD_S_000020_PKG dependencies on FND_LOOKUP_VALUES

Line 143986: , fnd_lookup_values fvl15

143982: END source_meaning
143983: FROM xla_events_gt xet
143984: , AP_INVOICE_EXTRACT_HEADER_V h2
143985: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
143986: , fnd_lookup_values fvl15
143987: , fnd_lookup_values fvl47
143988: , fnd_lookup_values fvl164
143989: ,(select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
143990: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 143987: , fnd_lookup_values fvl47

143983: FROM xla_events_gt xet
143984: , AP_INVOICE_EXTRACT_HEADER_V h2
143985: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
143986: , fnd_lookup_values fvl15
143987: , fnd_lookup_values fvl47
143988: , fnd_lookup_values fvl164
143989: ,(select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
143990: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143991: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 143988: , fnd_lookup_values fvl164

143984: , AP_INVOICE_EXTRACT_HEADER_V h2
143985: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
143986: , fnd_lookup_values fvl15
143987: , fnd_lookup_values fvl47
143988: , fnd_lookup_values fvl164
143989: ,(select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
143990: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143991: AND xet.event_class_code = C_EVENT_CLASS_CODE
143992: AND h2.event_id = xet.event_id

Line 144345: , fnd_lookup_values fvl22

144341: , AP_INVOICE_EXTRACT_DETAILS_V l1
144342: , AP_PO_HEADERS_EXTRACT_V l3
144343: , ZX_AP_DEF_TAX_EXTRACT_V l5
144344: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144345: , fnd_lookup_values fvl22
144346: , fnd_lookup_values fvl33
144347: , fnd_lookup_values fvl79
144348: , fnd_lookup_values fvl95
144349: , fnd_lookup_values fvl135

Line 144346: , fnd_lookup_values fvl33

144342: , AP_PO_HEADERS_EXTRACT_V l3
144343: , ZX_AP_DEF_TAX_EXTRACT_V l5
144344: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144345: , fnd_lookup_values fvl22
144346: , fnd_lookup_values fvl33
144347: , fnd_lookup_values fvl79
144348: , fnd_lookup_values fvl95
144349: , fnd_lookup_values fvl135
144350: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)

Line 144347: , fnd_lookup_values fvl79

144343: , ZX_AP_DEF_TAX_EXTRACT_V l5
144344: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144345: , fnd_lookup_values fvl22
144346: , fnd_lookup_values fvl33
144347: , fnd_lookup_values fvl79
144348: , fnd_lookup_values fvl95
144349: , fnd_lookup_values fvl135
144350: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
144351: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 144348: , fnd_lookup_values fvl95

144344: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144345: , fnd_lookup_values fvl22
144346: , fnd_lookup_values fvl33
144347: , fnd_lookup_values fvl79
144348: , fnd_lookup_values fvl95
144349: , fnd_lookup_values fvl135
144350: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
144351: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144352: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 144349: , fnd_lookup_values fvl135

144345: , fnd_lookup_values fvl22
144346: , fnd_lookup_values fvl33
144347: , fnd_lookup_values fvl79
144348: , fnd_lookup_values fvl95
144349: , fnd_lookup_values fvl135
144350: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
144351: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144352: AND xet.event_class_code = C_EVENT_CLASS_CODE
144353: AND l1.event_id = xet.event_id

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

144500: l_balance_type_code VARCHAR2(1) :=NULL;
144501: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
144502:
144503: --
144504: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
144505: --
144506:
144507: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144508: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 144719: , fnd_lookup_values fvl15

144715: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
144716: FROM xla_events_gt xet
144717: , AP_INVOICE_EXTRACT_HEADER_V h2
144718: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144719: , fnd_lookup_values fvl15
144720: , fnd_lookup_values fvl47
144721: , fnd_lookup_values fvl164
144722: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
144723: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 144720: , fnd_lookup_values fvl47

144716: FROM xla_events_gt xet
144717: , AP_INVOICE_EXTRACT_HEADER_V h2
144718: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144719: , fnd_lookup_values fvl15
144720: , fnd_lookup_values fvl47
144721: , fnd_lookup_values fvl164
144722: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
144723: and xet.event_class_code = C_EVENT_CLASS_CODE
144724: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 144721: , fnd_lookup_values fvl164

144717: , AP_INVOICE_EXTRACT_HEADER_V h2
144718: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144719: , fnd_lookup_values fvl15
144720: , fnd_lookup_values fvl47
144721: , fnd_lookup_values fvl164
144722: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
144723: and xet.event_class_code = C_EVENT_CLASS_CODE
144724: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
144725: AND h4.asp_org_id = h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 144830: , fnd_lookup_values fvl22

144826: , AP_INVOICE_EXTRACT_DETAILS_V l1
144827: , AP_PO_HEADERS_EXTRACT_V l3
144828: , ZX_AP_DEF_TAX_EXTRACT_V l5
144829: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144830: , fnd_lookup_values fvl22
144831: , fnd_lookup_values fvl33
144832: , fnd_lookup_values fvl79
144833: , fnd_lookup_values fvl95
144834: , fnd_lookup_values fvl135

Line 144831: , fnd_lookup_values fvl33

144827: , AP_PO_HEADERS_EXTRACT_V l3
144828: , ZX_AP_DEF_TAX_EXTRACT_V l5
144829: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144830: , fnd_lookup_values fvl22
144831: , fnd_lookup_values fvl33
144832: , fnd_lookup_values fvl79
144833: , fnd_lookup_values fvl95
144834: , fnd_lookup_values fvl135
144835: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 144832: , fnd_lookup_values fvl79

144828: , ZX_AP_DEF_TAX_EXTRACT_V l5
144829: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144830: , fnd_lookup_values fvl22
144831: , fnd_lookup_values fvl33
144832: , fnd_lookup_values fvl79
144833: , fnd_lookup_values fvl95
144834: , fnd_lookup_values fvl135
144835: WHERE xet.event_id between x_first_event_id and x_last_event_id
144836: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 144833: , fnd_lookup_values fvl95

144829: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144830: , fnd_lookup_values fvl22
144831: , fnd_lookup_values fvl33
144832: , fnd_lookup_values fvl79
144833: , fnd_lookup_values fvl95
144834: , fnd_lookup_values fvl135
144835: WHERE xet.event_id between x_first_event_id and x_last_event_id
144836: and xet.event_date between p_pad_start_date and p_pad_end_date
144837: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 144834: , fnd_lookup_values fvl135

144830: , fnd_lookup_values fvl22
144831: , fnd_lookup_values fvl33
144832: , fnd_lookup_values fvl79
144833: , fnd_lookup_values fvl95
144834: , fnd_lookup_values fvl135
144835: WHERE xet.event_id between x_first_event_id and x_last_event_id
144836: and xet.event_date between p_pad_start_date and p_pad_end_date
144837: and xet.event_class_code = C_EVENT_CLASS_CODE
144838: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 147305: , fnd_lookup_values fvl15

147301: END source_meaning
147302: FROM xla_events_gt xet
147303: , AP_INVOICE_EXTRACT_HEADER_V h2
147304: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
147305: , fnd_lookup_values fvl15
147306: , fnd_lookup_values fvl47
147307: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
147308: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147309: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 147306: , fnd_lookup_values fvl47

147302: FROM xla_events_gt xet
147303: , AP_INVOICE_EXTRACT_HEADER_V h2
147304: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
147305: , fnd_lookup_values fvl15
147306: , fnd_lookup_values fvl47
147307: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
147308: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147309: AND xet.event_class_code = C_EVENT_CLASS_CODE
147310: AND h2.event_id = xet.event_id

Line 147654: , fnd_lookup_values fvl22

147650: , AP_INVOICE_EXTRACT_DETAILS_V l1
147651: , AP_PO_HEADERS_EXTRACT_V l3
147652: , ZX_AP_DEF_TAX_EXTRACT_V l5
147653: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
147654: , fnd_lookup_values fvl22
147655: , fnd_lookup_values fvl33
147656: , fnd_lookup_values fvl79
147657: , fnd_lookup_values fvl95
147658: , fnd_lookup_values fvl135

Line 147655: , fnd_lookup_values fvl33

147651: , AP_PO_HEADERS_EXTRACT_V l3
147652: , ZX_AP_DEF_TAX_EXTRACT_V l5
147653: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
147654: , fnd_lookup_values fvl22
147655: , fnd_lookup_values fvl33
147656: , fnd_lookup_values fvl79
147657: , fnd_lookup_values fvl95
147658: , fnd_lookup_values fvl135
147659: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)

Line 147656: , fnd_lookup_values fvl79

147652: , ZX_AP_DEF_TAX_EXTRACT_V l5
147653: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
147654: , fnd_lookup_values fvl22
147655: , fnd_lookup_values fvl33
147656: , fnd_lookup_values fvl79
147657: , fnd_lookup_values fvl95
147658: , fnd_lookup_values fvl135
147659: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
147660: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 147657: , fnd_lookup_values fvl95

147653: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
147654: , fnd_lookup_values fvl22
147655: , fnd_lookup_values fvl33
147656: , fnd_lookup_values fvl79
147657: , fnd_lookup_values fvl95
147658: , fnd_lookup_values fvl135
147659: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
147660: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147661: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 147658: , fnd_lookup_values fvl135

147654: , fnd_lookup_values fvl22
147655: , fnd_lookup_values fvl33
147656: , fnd_lookup_values fvl79
147657: , fnd_lookup_values fvl95
147658: , fnd_lookup_values fvl135
147659: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
147660: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147661: AND xet.event_class_code = C_EVENT_CLASS_CODE
147662: AND l1.event_id = xet.event_id

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

147809: l_balance_type_code VARCHAR2(1) :=NULL;
147810: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
147811:
147812: --
147813: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
147814: --
147815:
147816: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
147817: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 148021: , fnd_lookup_values fvl15

148017: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
148018: FROM xla_events_gt xet
148019: , AP_INVOICE_EXTRACT_HEADER_V h2
148020: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
148021: , fnd_lookup_values fvl15
148022: , fnd_lookup_values fvl47
148023: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
148024: and xet.event_class_code = C_EVENT_CLASS_CODE
148025: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 148022: , fnd_lookup_values fvl47

148018: FROM xla_events_gt xet
148019: , AP_INVOICE_EXTRACT_HEADER_V h2
148020: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
148021: , fnd_lookup_values fvl15
148022: , fnd_lookup_values fvl47
148023: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
148024: and xet.event_class_code = C_EVENT_CLASS_CODE
148025: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
148026: AND h4.asp_org_id= h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 148126: , fnd_lookup_values fvl22

148122: , AP_INVOICE_EXTRACT_DETAILS_V l1
148123: , AP_PO_HEADERS_EXTRACT_V l3
148124: , ZX_AP_DEF_TAX_EXTRACT_V l5
148125: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
148126: , fnd_lookup_values fvl22
148127: , fnd_lookup_values fvl33
148128: , fnd_lookup_values fvl79
148129: , fnd_lookup_values fvl95
148130: , fnd_lookup_values fvl135

Line 148127: , fnd_lookup_values fvl33

148123: , AP_PO_HEADERS_EXTRACT_V l3
148124: , ZX_AP_DEF_TAX_EXTRACT_V l5
148125: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
148126: , fnd_lookup_values fvl22
148127: , fnd_lookup_values fvl33
148128: , fnd_lookup_values fvl79
148129: , fnd_lookup_values fvl95
148130: , fnd_lookup_values fvl135
148131: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 148128: , fnd_lookup_values fvl79

148124: , ZX_AP_DEF_TAX_EXTRACT_V l5
148125: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
148126: , fnd_lookup_values fvl22
148127: , fnd_lookup_values fvl33
148128: , fnd_lookup_values fvl79
148129: , fnd_lookup_values fvl95
148130: , fnd_lookup_values fvl135
148131: WHERE xet.event_id between x_first_event_id and x_last_event_id
148132: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 148129: , fnd_lookup_values fvl95

148125: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
148126: , fnd_lookup_values fvl22
148127: , fnd_lookup_values fvl33
148128: , fnd_lookup_values fvl79
148129: , fnd_lookup_values fvl95
148130: , fnd_lookup_values fvl135
148131: WHERE xet.event_id between x_first_event_id and x_last_event_id
148132: and xet.event_date between p_pad_start_date and p_pad_end_date
148133: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 148130: , fnd_lookup_values fvl135

148126: , fnd_lookup_values fvl22
148127: , fnd_lookup_values fvl33
148128: , fnd_lookup_values fvl79
148129: , fnd_lookup_values fvl95
148130: , fnd_lookup_values fvl135
148131: WHERE xet.event_id between x_first_event_id and x_last_event_id
148132: and xet.event_date between p_pad_start_date and p_pad_end_date
148133: and xet.event_class_code = C_EVENT_CLASS_CODE
148134: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 150597: , fnd_lookup_values fvl15

150593: END source_meaning
150594: FROM xla_events_gt xet
150595: , AP_PAYMENT_EXTRACT_HEADER_V h2
150596: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
150597: , fnd_lookup_values fvl15
150598: , fnd_lookup_values fvl47
150599: , fnd_lookup_values fvl113
150600: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
150601: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 150598: , fnd_lookup_values fvl47

150594: FROM xla_events_gt xet
150595: , AP_PAYMENT_EXTRACT_HEADER_V h2
150596: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
150597: , fnd_lookup_values fvl15
150598: , fnd_lookup_values fvl47
150599: , fnd_lookup_values fvl113
150600: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
150601: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150602: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 150599: , fnd_lookup_values fvl113

150595: , AP_PAYMENT_EXTRACT_HEADER_V h2
150596: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
150597: , fnd_lookup_values fvl15
150598: , fnd_lookup_values fvl47
150599: , fnd_lookup_values fvl113
150600: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
150601: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150602: AND xet.event_class_code = C_EVENT_CLASS_CODE
150603: AND h2.event_id = xet.event_id

Line 150838: , fnd_lookup_values fvl33

150834: END source_meaning
150835: FROM xla_events_gt xet
150836: , AP_PAYMENT_EXTRACT_DETAILS_V l1
150837: , ZX_AP_DEF_TAX_EXTRACT_V l4
150838: , fnd_lookup_values fvl33
150839: , fnd_lookup_values fvl79
150840: , fnd_lookup_values fvl97
150841: , fnd_lookup_values fvl125
150842: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

Line 150839: , fnd_lookup_values fvl79

150835: FROM xla_events_gt xet
150836: , AP_PAYMENT_EXTRACT_DETAILS_V l1
150837: , ZX_AP_DEF_TAX_EXTRACT_V l4
150838: , fnd_lookup_values fvl33
150839: , fnd_lookup_values fvl79
150840: , fnd_lookup_values fvl97
150841: , fnd_lookup_values fvl125
150842: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
150843: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 150840: , fnd_lookup_values fvl97

150836: , AP_PAYMENT_EXTRACT_DETAILS_V l1
150837: , ZX_AP_DEF_TAX_EXTRACT_V l4
150838: , fnd_lookup_values fvl33
150839: , fnd_lookup_values fvl79
150840: , fnd_lookup_values fvl97
150841: , fnd_lookup_values fvl125
150842: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
150843: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150844: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 150841: , fnd_lookup_values fvl125

150837: , ZX_AP_DEF_TAX_EXTRACT_V l4
150838: , fnd_lookup_values fvl33
150839: , fnd_lookup_values fvl79
150840: , fnd_lookup_values fvl97
150841: , fnd_lookup_values fvl125
150842: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
150843: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150844: AND xet.event_class_code = C_EVENT_CLASS_CODE
150845: AND l1.event_id = xet.event_id

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

150988: l_balance_type_code VARCHAR2(1) :=NULL;
150989: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
150990:
150991: --
150992: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
150993: --
150994:
150995: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
150996: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 151172: , fnd_lookup_values fvl15

151168: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
151169: FROM xla_events_gt xet
151170: , AP_PAYMENT_EXTRACT_HEADER_V h2
151171: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
151172: , fnd_lookup_values fvl15
151173: , fnd_lookup_values fvl47
151174: , fnd_lookup_values fvl113
151175: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
151176: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 151173: , fnd_lookup_values fvl47

151169: FROM xla_events_gt xet
151170: , AP_PAYMENT_EXTRACT_HEADER_V h2
151171: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
151172: , fnd_lookup_values fvl15
151173: , fnd_lookup_values fvl47
151174: , fnd_lookup_values fvl113
151175: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
151176: and xet.event_class_code = C_EVENT_CLASS_CODE
151177: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 151174: , fnd_lookup_values fvl113

151170: , AP_PAYMENT_EXTRACT_HEADER_V h2
151171: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
151172: , fnd_lookup_values fvl15
151173: , fnd_lookup_values fvl47
151174: , fnd_lookup_values fvl113
151175: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
151176: and xet.event_class_code = C_EVENT_CLASS_CODE
151177: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
151178: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 151257: , fnd_lookup_values fvl33

151253: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_158
151254: FROM xla_events_gt xet
151255: , AP_PAYMENT_EXTRACT_DETAILS_V l1
151256: , ZX_AP_DEF_TAX_EXTRACT_V l4
151257: , fnd_lookup_values fvl33
151258: , fnd_lookup_values fvl79
151259: , fnd_lookup_values fvl97
151260: , fnd_lookup_values fvl125
151261: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 151258: , fnd_lookup_values fvl79

151254: FROM xla_events_gt xet
151255: , AP_PAYMENT_EXTRACT_DETAILS_V l1
151256: , ZX_AP_DEF_TAX_EXTRACT_V l4
151257: , fnd_lookup_values fvl33
151258: , fnd_lookup_values fvl79
151259: , fnd_lookup_values fvl97
151260: , fnd_lookup_values fvl125
151261: WHERE xet.event_id between x_first_event_id and x_last_event_id
151262: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 151259: , fnd_lookup_values fvl97

151255: , AP_PAYMENT_EXTRACT_DETAILS_V l1
151256: , ZX_AP_DEF_TAX_EXTRACT_V l4
151257: , fnd_lookup_values fvl33
151258: , fnd_lookup_values fvl79
151259: , fnd_lookup_values fvl97
151260: , fnd_lookup_values fvl125
151261: WHERE xet.event_id between x_first_event_id and x_last_event_id
151262: and xet.event_date between p_pad_start_date and p_pad_end_date
151263: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 151260: , fnd_lookup_values fvl125

151256: , ZX_AP_DEF_TAX_EXTRACT_V l4
151257: , fnd_lookup_values fvl33
151258: , fnd_lookup_values fvl79
151259: , fnd_lookup_values fvl97
151260: , fnd_lookup_values fvl125
151261: WHERE xet.event_id between x_first_event_id and x_last_event_id
151262: and xet.event_date between p_pad_start_date and p_pad_end_date
151263: and xet.event_class_code = C_EVENT_CLASS_CODE
151264: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 152975: , fnd_lookup_values fvl15

152971: END source_meaning
152972: FROM xla_events_gt xet
152973: , AP_INVOICE_EXTRACT_HEADER_V h2
152974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152975: , fnd_lookup_values fvl15
152976: , fnd_lookup_values fvl47
152977: , fnd_lookup_values fvl164
152978: ,(select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
152979: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 152976: , fnd_lookup_values fvl47

152972: FROM xla_events_gt xet
152973: , AP_INVOICE_EXTRACT_HEADER_V h2
152974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152975: , fnd_lookup_values fvl15
152976: , fnd_lookup_values fvl47
152977: , fnd_lookup_values fvl164
152978: ,(select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
152979: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
152980: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 152977: , fnd_lookup_values fvl164

152973: , AP_INVOICE_EXTRACT_HEADER_V h2
152974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152975: , fnd_lookup_values fvl15
152976: , fnd_lookup_values fvl47
152977: , fnd_lookup_values fvl164
152978: ,(select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
152979: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
152980: AND xet.event_class_code = C_EVENT_CLASS_CODE
152981: AND h2.event_id = xet.event_id

Line 153344: , fnd_lookup_values fvl22

153340: , AP_INVOICE_EXTRACT_DETAILS_V l1
153341: , AP_PO_HEADERS_EXTRACT_V l3
153342: , ZX_AP_DEF_TAX_EXTRACT_V l5
153343: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153344: , fnd_lookup_values fvl22
153345: , fnd_lookup_values fvl33
153346: , fnd_lookup_values fvl79
153347: , fnd_lookup_values fvl95
153348: , fnd_lookup_values fvl135

Line 153345: , fnd_lookup_values fvl33

153341: , AP_PO_HEADERS_EXTRACT_V l3
153342: , ZX_AP_DEF_TAX_EXTRACT_V l5
153343: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153344: , fnd_lookup_values fvl22
153345: , fnd_lookup_values fvl33
153346: , fnd_lookup_values fvl79
153347: , fnd_lookup_values fvl95
153348: , fnd_lookup_values fvl135
153349: , (select rownum r from all_objects where rownum <= 50 and owner = p_apps_owner)

Line 153346: , fnd_lookup_values fvl79

153342: , ZX_AP_DEF_TAX_EXTRACT_V l5
153343: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153344: , fnd_lookup_values fvl22
153345: , fnd_lookup_values fvl33
153346: , fnd_lookup_values fvl79
153347: , fnd_lookup_values fvl95
153348: , fnd_lookup_values fvl135
153349: , (select rownum r from all_objects where rownum <= 50 and owner = p_apps_owner)
153350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 153347: , fnd_lookup_values fvl95

153343: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153344: , fnd_lookup_values fvl22
153345: , fnd_lookup_values fvl33
153346: , fnd_lookup_values fvl79
153347: , fnd_lookup_values fvl95
153348: , fnd_lookup_values fvl135
153349: , (select rownum r from all_objects where rownum <= 50 and owner = p_apps_owner)
153350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153351: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 153348: , fnd_lookup_values fvl135

153344: , fnd_lookup_values fvl22
153345: , fnd_lookup_values fvl33
153346: , fnd_lookup_values fvl79
153347: , fnd_lookup_values fvl95
153348: , fnd_lookup_values fvl135
153349: , (select rownum r from all_objects where rownum <= 50 and owner = p_apps_owner)
153350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153351: AND xet.event_class_code = C_EVENT_CLASS_CODE
153352: AND l1.event_id = xet.event_id

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

153499: l_balance_type_code VARCHAR2(1) :=NULL;
153500: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
153501:
153502: --
153503: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153504: --
153505:
153506: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
153507: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 153722: , fnd_lookup_values fvl15

153718: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
153719: FROM xla_events_gt xet
153720: , AP_INVOICE_EXTRACT_HEADER_V h2
153721: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153722: , fnd_lookup_values fvl15
153723: , fnd_lookup_values fvl47
153724: , fnd_lookup_values fvl164
153725: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153726: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 153723: , fnd_lookup_values fvl47

153719: FROM xla_events_gt xet
153720: , AP_INVOICE_EXTRACT_HEADER_V h2
153721: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153722: , fnd_lookup_values fvl15
153723: , fnd_lookup_values fvl47
153724: , fnd_lookup_values fvl164
153725: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153726: and xet.event_class_code = C_EVENT_CLASS_CODE
153727: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 153724: , fnd_lookup_values fvl164

153720: , AP_INVOICE_EXTRACT_HEADER_V h2
153721: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153722: , fnd_lookup_values fvl15
153723: , fnd_lookup_values fvl47
153724: , fnd_lookup_values fvl164
153725: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153726: and xet.event_class_code = C_EVENT_CLASS_CODE
153727: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
153728: AND h4.asp_org_id = h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 153835: , fnd_lookup_values fvl22

153831: , AP_INVOICE_EXTRACT_DETAILS_V l1
153832: , AP_PO_HEADERS_EXTRACT_V l3
153833: , ZX_AP_DEF_TAX_EXTRACT_V l5
153834: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153835: , fnd_lookup_values fvl22
153836: , fnd_lookup_values fvl33
153837: , fnd_lookup_values fvl79
153838: , fnd_lookup_values fvl95
153839: , fnd_lookup_values fvl135

Line 153836: , fnd_lookup_values fvl33

153832: , AP_PO_HEADERS_EXTRACT_V l3
153833: , ZX_AP_DEF_TAX_EXTRACT_V l5
153834: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153835: , fnd_lookup_values fvl22
153836: , fnd_lookup_values fvl33
153837: , fnd_lookup_values fvl79
153838: , fnd_lookup_values fvl95
153839: , fnd_lookup_values fvl135
153840: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 153837: , fnd_lookup_values fvl79

153833: , ZX_AP_DEF_TAX_EXTRACT_V l5
153834: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153835: , fnd_lookup_values fvl22
153836: , fnd_lookup_values fvl33
153837: , fnd_lookup_values fvl79
153838: , fnd_lookup_values fvl95
153839: , fnd_lookup_values fvl135
153840: WHERE xet.event_id between x_first_event_id and x_last_event_id
153841: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 153838: , fnd_lookup_values fvl95

153834: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153835: , fnd_lookup_values fvl22
153836: , fnd_lookup_values fvl33
153837: , fnd_lookup_values fvl79
153838: , fnd_lookup_values fvl95
153839: , fnd_lookup_values fvl135
153840: WHERE xet.event_id between x_first_event_id and x_last_event_id
153841: and xet.event_date between p_pad_start_date and p_pad_end_date
153842: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 153839: , fnd_lookup_values fvl135

153835: , fnd_lookup_values fvl22
153836: , fnd_lookup_values fvl33
153837: , fnd_lookup_values fvl79
153838: , fnd_lookup_values fvl95
153839: , fnd_lookup_values fvl135
153840: WHERE xet.event_id between x_first_event_id and x_last_event_id
153841: and xet.event_date between p_pad_start_date and p_pad_end_date
153842: and xet.event_class_code = C_EVENT_CLASS_CODE
153843: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 156466: , fnd_lookup_values fvl15

156462: END source_meaning
156463: FROM xla_events_gt xet
156464: , AP_PAYMENT_EXTRACT_HEADER_V h2
156465: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
156466: , fnd_lookup_values fvl15
156467: , fnd_lookup_values fvl19
156468: , fnd_lookup_values fvl25
156469: , fnd_lookup_values fvl47
156470: , fnd_lookup_values fvl113

Line 156467: , fnd_lookup_values fvl19

156463: FROM xla_events_gt xet
156464: , AP_PAYMENT_EXTRACT_HEADER_V h2
156465: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
156466: , fnd_lookup_values fvl15
156467: , fnd_lookup_values fvl19
156468: , fnd_lookup_values fvl25
156469: , fnd_lookup_values fvl47
156470: , fnd_lookup_values fvl113
156471: , fnd_lookup_values fvl122

Line 156468: , fnd_lookup_values fvl25

156464: , AP_PAYMENT_EXTRACT_HEADER_V h2
156465: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
156466: , fnd_lookup_values fvl15
156467: , fnd_lookup_values fvl19
156468: , fnd_lookup_values fvl25
156469: , fnd_lookup_values fvl47
156470: , fnd_lookup_values fvl113
156471: , fnd_lookup_values fvl122
156472: , fnd_lookup_values fvl172

Line 156469: , fnd_lookup_values fvl47

156465: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
156466: , fnd_lookup_values fvl15
156467: , fnd_lookup_values fvl19
156468: , fnd_lookup_values fvl25
156469: , fnd_lookup_values fvl47
156470: , fnd_lookup_values fvl113
156471: , fnd_lookup_values fvl122
156472: , fnd_lookup_values fvl172
156473: ,(select rownum r from all_objects where rownum <= 39 and owner = p_apps_owner)

Line 156470: , fnd_lookup_values fvl113

156466: , fnd_lookup_values fvl15
156467: , fnd_lookup_values fvl19
156468: , fnd_lookup_values fvl25
156469: , fnd_lookup_values fvl47
156470: , fnd_lookup_values fvl113
156471: , fnd_lookup_values fvl122
156472: , fnd_lookup_values fvl172
156473: ,(select rownum r from all_objects where rownum <= 39 and owner = p_apps_owner)
156474: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 156471: , fnd_lookup_values fvl122

156467: , fnd_lookup_values fvl19
156468: , fnd_lookup_values fvl25
156469: , fnd_lookup_values fvl47
156470: , fnd_lookup_values fvl113
156471: , fnd_lookup_values fvl122
156472: , fnd_lookup_values fvl172
156473: ,(select rownum r from all_objects where rownum <= 39 and owner = p_apps_owner)
156474: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156475: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 156472: , fnd_lookup_values fvl172

156468: , fnd_lookup_values fvl25
156469: , fnd_lookup_values fvl47
156470: , fnd_lookup_values fvl113
156471: , fnd_lookup_values fvl122
156472: , fnd_lookup_values fvl172
156473: ,(select rownum r from all_objects where rownum <= 39 and owner = p_apps_owner)
156474: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156475: AND xet.event_class_code = C_EVENT_CLASS_CODE
156476: AND h2.event_id = xet.event_id

Line 156775: , fnd_lookup_values fvl33

156771: FROM xla_events_gt xet
156772: , AP_PAYMENT_EXTRACT_DETAILS_V l1
156773: , ZX_AP_DEF_TAX_EXTRACT_V l4
156774: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
156775: , fnd_lookup_values fvl33
156776: , fnd_lookup_values fvl79
156777: , fnd_lookup_values fvl97
156778: , fnd_lookup_values fvl125
156779: , fnd_lookup_values fvl160

Line 156776: , fnd_lookup_values fvl79

156772: , AP_PAYMENT_EXTRACT_DETAILS_V l1
156773: , ZX_AP_DEF_TAX_EXTRACT_V l4
156774: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
156775: , fnd_lookup_values fvl33
156776: , fnd_lookup_values fvl79
156777: , fnd_lookup_values fvl97
156778: , fnd_lookup_values fvl125
156779: , fnd_lookup_values fvl160
156780: , fnd_lookup_values fvl161

Line 156777: , fnd_lookup_values fvl97

156773: , ZX_AP_DEF_TAX_EXTRACT_V l4
156774: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
156775: , fnd_lookup_values fvl33
156776: , fnd_lookup_values fvl79
156777: , fnd_lookup_values fvl97
156778: , fnd_lookup_values fvl125
156779: , fnd_lookup_values fvl160
156780: , fnd_lookup_values fvl161
156781: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)

Line 156778: , fnd_lookup_values fvl125

156774: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
156775: , fnd_lookup_values fvl33
156776: , fnd_lookup_values fvl79
156777: , fnd_lookup_values fvl97
156778: , fnd_lookup_values fvl125
156779: , fnd_lookup_values fvl160
156780: , fnd_lookup_values fvl161
156781: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)
156782: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 156779: , fnd_lookup_values fvl160

156775: , fnd_lookup_values fvl33
156776: , fnd_lookup_values fvl79
156777: , fnd_lookup_values fvl97
156778: , fnd_lookup_values fvl125
156779: , fnd_lookup_values fvl160
156780: , fnd_lookup_values fvl161
156781: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)
156782: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156783: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 156780: , fnd_lookup_values fvl161

156776: , fnd_lookup_values fvl79
156777: , fnd_lookup_values fvl97
156778: , fnd_lookup_values fvl125
156779: , fnd_lookup_values fvl160
156780: , fnd_lookup_values fvl161
156781: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)
156782: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156783: AND xet.event_class_code = C_EVENT_CLASS_CODE
156784: AND l1.event_id = xet.event_id

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

156935: l_balance_type_code VARCHAR2(1) :=NULL;
156936: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
156937:
156938: --
156939: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
156940: --
156941:
156942: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
156943: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 157183: , fnd_lookup_values fvl15

157179: , fvl172.meaning source_172_meaning
157180: FROM xla_events_gt xet
157181: , AP_PAYMENT_EXTRACT_HEADER_V h2
157182: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
157183: , fnd_lookup_values fvl15
157184: , fnd_lookup_values fvl19
157185: , fnd_lookup_values fvl25
157186: , fnd_lookup_values fvl47
157187: , fnd_lookup_values fvl113

Line 157184: , fnd_lookup_values fvl19

157180: FROM xla_events_gt xet
157181: , AP_PAYMENT_EXTRACT_HEADER_V h2
157182: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
157183: , fnd_lookup_values fvl15
157184: , fnd_lookup_values fvl19
157185: , fnd_lookup_values fvl25
157186: , fnd_lookup_values fvl47
157187: , fnd_lookup_values fvl113
157188: , fnd_lookup_values fvl122

Line 157185: , fnd_lookup_values fvl25

157181: , AP_PAYMENT_EXTRACT_HEADER_V h2
157182: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
157183: , fnd_lookup_values fvl15
157184: , fnd_lookup_values fvl19
157185: , fnd_lookup_values fvl25
157186: , fnd_lookup_values fvl47
157187: , fnd_lookup_values fvl113
157188: , fnd_lookup_values fvl122
157189: , fnd_lookup_values fvl172

Line 157186: , fnd_lookup_values fvl47

157182: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
157183: , fnd_lookup_values fvl15
157184: , fnd_lookup_values fvl19
157185: , fnd_lookup_values fvl25
157186: , fnd_lookup_values fvl47
157187: , fnd_lookup_values fvl113
157188: , fnd_lookup_values fvl122
157189: , fnd_lookup_values fvl172
157190: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 157187: , fnd_lookup_values fvl113

157183: , fnd_lookup_values fvl15
157184: , fnd_lookup_values fvl19
157185: , fnd_lookup_values fvl25
157186: , fnd_lookup_values fvl47
157187: , fnd_lookup_values fvl113
157188: , fnd_lookup_values fvl122
157189: , fnd_lookup_values fvl172
157190: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
157191: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 157188: , fnd_lookup_values fvl122

157184: , fnd_lookup_values fvl19
157185: , fnd_lookup_values fvl25
157186: , fnd_lookup_values fvl47
157187: , fnd_lookup_values fvl113
157188: , fnd_lookup_values fvl122
157189: , fnd_lookup_values fvl172
157190: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
157191: and xet.event_class_code = C_EVENT_CLASS_CODE
157192: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 157189: , fnd_lookup_values fvl172

157185: , fnd_lookup_values fvl25
157186: , fnd_lookup_values fvl47
157187: , fnd_lookup_values fvl113
157188: , fnd_lookup_values fvl122
157189: , fnd_lookup_values fvl172
157190: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
157191: and xet.event_class_code = C_EVENT_CLASS_CODE
157192: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
157193: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 157300: , fnd_lookup_values fvl33

157296: FROM xla_events_gt xet
157297: , AP_PAYMENT_EXTRACT_DETAILS_V l1
157298: , ZX_AP_DEF_TAX_EXTRACT_V l4
157299: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
157300: , fnd_lookup_values fvl33
157301: , fnd_lookup_values fvl79
157302: , fnd_lookup_values fvl97
157303: , fnd_lookup_values fvl125
157304: , fnd_lookup_values fvl160

Line 157301: , fnd_lookup_values fvl79

157297: , AP_PAYMENT_EXTRACT_DETAILS_V l1
157298: , ZX_AP_DEF_TAX_EXTRACT_V l4
157299: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
157300: , fnd_lookup_values fvl33
157301: , fnd_lookup_values fvl79
157302: , fnd_lookup_values fvl97
157303: , fnd_lookup_values fvl125
157304: , fnd_lookup_values fvl160
157305: , fnd_lookup_values fvl161

Line 157302: , fnd_lookup_values fvl97

157298: , ZX_AP_DEF_TAX_EXTRACT_V l4
157299: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
157300: , fnd_lookup_values fvl33
157301: , fnd_lookup_values fvl79
157302: , fnd_lookup_values fvl97
157303: , fnd_lookup_values fvl125
157304: , fnd_lookup_values fvl160
157305: , fnd_lookup_values fvl161
157306: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 157303: , fnd_lookup_values fvl125

157299: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
157300: , fnd_lookup_values fvl33
157301: , fnd_lookup_values fvl79
157302: , fnd_lookup_values fvl97
157303: , fnd_lookup_values fvl125
157304: , fnd_lookup_values fvl160
157305: , fnd_lookup_values fvl161
157306: WHERE xet.event_id between x_first_event_id and x_last_event_id
157307: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 157304: , fnd_lookup_values fvl160

157300: , fnd_lookup_values fvl33
157301: , fnd_lookup_values fvl79
157302: , fnd_lookup_values fvl97
157303: , fnd_lookup_values fvl125
157304: , fnd_lookup_values fvl160
157305: , fnd_lookup_values fvl161
157306: WHERE xet.event_id between x_first_event_id and x_last_event_id
157307: and xet.event_date between p_pad_start_date and p_pad_end_date
157308: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 157305: , fnd_lookup_values fvl161

157301: , fnd_lookup_values fvl79
157302: , fnd_lookup_values fvl97
157303: , fnd_lookup_values fvl125
157304: , fnd_lookup_values fvl160
157305: , fnd_lookup_values fvl161
157306: WHERE xet.event_id between x_first_event_id and x_last_event_id
157307: and xet.event_date between p_pad_start_date and p_pad_end_date
157308: and xet.event_class_code = C_EVENT_CLASS_CODE
157309: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 159478: , fnd_lookup_values fvl15

159474: END source_meaning
159475: FROM xla_events_gt xet
159476: , AP_INVOICE_EXTRACT_HEADER_V h1
159477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
159478: , fnd_lookup_values fvl15
159479: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
159480: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159481: AND xet.event_class_code = C_EVENT_CLASS_CODE
159482: AND h1.event_id = xet.event_id

Line 159810: , fnd_lookup_values fvl79

159806: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
159807: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
159808: , ZX_AP_DEF_TAX_EXTRACT_V l5
159809: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
159810: , fnd_lookup_values fvl79
159811: , fnd_lookup_values fvl125
159812: , fnd_lookup_values fvl165
159813: , (select rownum r from all_objects where rownum <= 45 and owner = p_apps_owner)
159814: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 159811: , fnd_lookup_values fvl125

159807: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
159808: , ZX_AP_DEF_TAX_EXTRACT_V l5
159809: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
159810: , fnd_lookup_values fvl79
159811: , fnd_lookup_values fvl125
159812: , fnd_lookup_values fvl165
159813: , (select rownum r from all_objects where rownum <= 45 and owner = p_apps_owner)
159814: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159815: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 159812: , fnd_lookup_values fvl165

159808: , ZX_AP_DEF_TAX_EXTRACT_V l5
159809: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
159810: , fnd_lookup_values fvl79
159811: , fnd_lookup_values fvl125
159812: , fnd_lookup_values fvl165
159813: , (select rownum r from all_objects where rownum <= 45 and owner = p_apps_owner)
159814: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159815: AND xet.event_class_code = C_EVENT_CLASS_CODE
159816: AND l2.event_id = xet.event_id

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

159955: l_balance_type_code VARCHAR2(1) :=NULL;
159956: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
159957:
159958: --
159959: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
159960: --
159961:
159962: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
159963: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 160141: , fnd_lookup_values fvl15

160137: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_168
160138: FROM xla_events_gt xet
160139: , AP_INVOICE_EXTRACT_HEADER_V h1
160140: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
160141: , fnd_lookup_values fvl15
160142: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160143: and xet.event_class_code = C_EVENT_CLASS_CODE
160144: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
160145: AND h4.asp_org_id = h1.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 160237: , fnd_lookup_values fvl79

160233: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
160234: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
160235: , ZX_AP_DEF_TAX_EXTRACT_V l5
160236: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
160237: , fnd_lookup_values fvl79
160238: , fnd_lookup_values fvl125
160239: , fnd_lookup_values fvl165
160240: WHERE xet.event_id between x_first_event_id and x_last_event_id
160241: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 160238: , fnd_lookup_values fvl125

160234: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
160235: , ZX_AP_DEF_TAX_EXTRACT_V l5
160236: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
160237: , fnd_lookup_values fvl79
160238: , fnd_lookup_values fvl125
160239: , fnd_lookup_values fvl165
160240: WHERE xet.event_id between x_first_event_id and x_last_event_id
160241: and xet.event_date between p_pad_start_date and p_pad_end_date
160242: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 160239: , fnd_lookup_values fvl165

160235: , ZX_AP_DEF_TAX_EXTRACT_V l5
160236: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
160237: , fnd_lookup_values fvl79
160238: , fnd_lookup_values fvl125
160239: , fnd_lookup_values fvl165
160240: WHERE xet.event_id between x_first_event_id and x_last_event_id
160241: and xet.event_date between p_pad_start_date and p_pad_end_date
160242: and xet.event_class_code = C_EVENT_CLASS_CODE
160243: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 161797: , fnd_lookup_values fvl15

161793: END source_meaning
161794: FROM xla_events_gt xet
161795: , AP_INVOICE_EXTRACT_HEADER_V h2
161796: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161797: , fnd_lookup_values fvl15
161798: , fnd_lookup_values fvl31
161799: , fnd_lookup_values fvl47
161800: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
161801: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 161798: , fnd_lookup_values fvl31

161794: FROM xla_events_gt xet
161795: , AP_INVOICE_EXTRACT_HEADER_V h2
161796: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161797: , fnd_lookup_values fvl15
161798: , fnd_lookup_values fvl31
161799: , fnd_lookup_values fvl47
161800: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
161801: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161802: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 161799: , fnd_lookup_values fvl47

161795: , AP_INVOICE_EXTRACT_HEADER_V h2
161796: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161797: , fnd_lookup_values fvl15
161798: , fnd_lookup_values fvl31
161799: , fnd_lookup_values fvl47
161800: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
161801: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161802: AND xet.event_class_code = C_EVENT_CLASS_CODE
161803: AND h2.event_id = xet.event_id

Line 162142: , fnd_lookup_values fvl22

162138: , AP_INVOICE_EXTRACT_DETAILS_V l1
162139: , AP_PO_HEADERS_EXTRACT_V l3
162140: , ZX_AP_DEF_TAX_EXTRACT_V l5
162141: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162142: , fnd_lookup_values fvl22
162143: , fnd_lookup_values fvl33
162144: , fnd_lookup_values fvl79
162145: , fnd_lookup_values fvl95
162146: , fnd_lookup_values fvl125

Line 162143: , fnd_lookup_values fvl33

162139: , AP_PO_HEADERS_EXTRACT_V l3
162140: , ZX_AP_DEF_TAX_EXTRACT_V l5
162141: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162142: , fnd_lookup_values fvl22
162143: , fnd_lookup_values fvl33
162144: , fnd_lookup_values fvl79
162145: , fnd_lookup_values fvl95
162146: , fnd_lookup_values fvl125
162147: , fnd_lookup_values fvl135

Line 162144: , fnd_lookup_values fvl79

162140: , ZX_AP_DEF_TAX_EXTRACT_V l5
162141: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162142: , fnd_lookup_values fvl22
162143: , fnd_lookup_values fvl33
162144: , fnd_lookup_values fvl79
162145: , fnd_lookup_values fvl95
162146: , fnd_lookup_values fvl125
162147: , fnd_lookup_values fvl135
162148: , (select rownum r from all_objects where rownum <= 45 and owner = p_apps_owner)

Line 162145: , fnd_lookup_values fvl95

162141: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162142: , fnd_lookup_values fvl22
162143: , fnd_lookup_values fvl33
162144: , fnd_lookup_values fvl79
162145: , fnd_lookup_values fvl95
162146: , fnd_lookup_values fvl125
162147: , fnd_lookup_values fvl135
162148: , (select rownum r from all_objects where rownum <= 45 and owner = p_apps_owner)
162149: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 162146: , fnd_lookup_values fvl125

162142: , fnd_lookup_values fvl22
162143: , fnd_lookup_values fvl33
162144: , fnd_lookup_values fvl79
162145: , fnd_lookup_values fvl95
162146: , fnd_lookup_values fvl125
162147: , fnd_lookup_values fvl135
162148: , (select rownum r from all_objects where rownum <= 45 and owner = p_apps_owner)
162149: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162150: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 162147: , fnd_lookup_values fvl135

162143: , fnd_lookup_values fvl33
162144: , fnd_lookup_values fvl79
162145: , fnd_lookup_values fvl95
162146: , fnd_lookup_values fvl125
162147: , fnd_lookup_values fvl135
162148: , (select rownum r from all_objects where rownum <= 45 and owner = p_apps_owner)
162149: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162150: AND xet.event_class_code = C_EVENT_CLASS_CODE
162151: AND l1.event_id = xet.event_id

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

162302: l_balance_type_code VARCHAR2(1) :=NULL;
162303: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
162304:
162305: --
162306: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
162307: --
162308:
162309: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
162310: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 162513: , fnd_lookup_values fvl15

162509: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
162510: FROM xla_events_gt xet
162511: , AP_INVOICE_EXTRACT_HEADER_V h2
162512: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162513: , fnd_lookup_values fvl15
162514: , fnd_lookup_values fvl31
162515: , fnd_lookup_values fvl47
162516: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162517: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 162514: , fnd_lookup_values fvl31

162510: FROM xla_events_gt xet
162511: , AP_INVOICE_EXTRACT_HEADER_V h2
162512: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162513: , fnd_lookup_values fvl15
162514: , fnd_lookup_values fvl31
162515: , fnd_lookup_values fvl47
162516: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162517: and xet.event_class_code = C_EVENT_CLASS_CODE
162518: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 162515: , fnd_lookup_values fvl47

162511: , AP_INVOICE_EXTRACT_HEADER_V h2
162512: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162513: , fnd_lookup_values fvl15
162514: , fnd_lookup_values fvl31
162515: , fnd_lookup_values fvl47
162516: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162517: and xet.event_class_code = C_EVENT_CLASS_CODE
162518: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
162519: AND h4.asp_org_id = h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 162622: , fnd_lookup_values fvl22

162618: , AP_INVOICE_EXTRACT_DETAILS_V l1
162619: , AP_PO_HEADERS_EXTRACT_V l3
162620: , ZX_AP_DEF_TAX_EXTRACT_V l5
162621: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162622: , fnd_lookup_values fvl22
162623: , fnd_lookup_values fvl33
162624: , fnd_lookup_values fvl79
162625: , fnd_lookup_values fvl95
162626: , fnd_lookup_values fvl125

Line 162623: , fnd_lookup_values fvl33

162619: , AP_PO_HEADERS_EXTRACT_V l3
162620: , ZX_AP_DEF_TAX_EXTRACT_V l5
162621: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162622: , fnd_lookup_values fvl22
162623: , fnd_lookup_values fvl33
162624: , fnd_lookup_values fvl79
162625: , fnd_lookup_values fvl95
162626: , fnd_lookup_values fvl125
162627: , fnd_lookup_values fvl135

Line 162624: , fnd_lookup_values fvl79

162620: , ZX_AP_DEF_TAX_EXTRACT_V l5
162621: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162622: , fnd_lookup_values fvl22
162623: , fnd_lookup_values fvl33
162624: , fnd_lookup_values fvl79
162625: , fnd_lookup_values fvl95
162626: , fnd_lookup_values fvl125
162627: , fnd_lookup_values fvl135
162628: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 162625: , fnd_lookup_values fvl95

162621: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162622: , fnd_lookup_values fvl22
162623: , fnd_lookup_values fvl33
162624: , fnd_lookup_values fvl79
162625: , fnd_lookup_values fvl95
162626: , fnd_lookup_values fvl125
162627: , fnd_lookup_values fvl135
162628: WHERE xet.event_id between x_first_event_id and x_last_event_id
162629: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 162626: , fnd_lookup_values fvl125

162622: , fnd_lookup_values fvl22
162623: , fnd_lookup_values fvl33
162624: , fnd_lookup_values fvl79
162625: , fnd_lookup_values fvl95
162626: , fnd_lookup_values fvl125
162627: , fnd_lookup_values fvl135
162628: WHERE xet.event_id between x_first_event_id and x_last_event_id
162629: and xet.event_date between p_pad_start_date and p_pad_end_date
162630: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 162627: , fnd_lookup_values fvl135

162623: , fnd_lookup_values fvl33
162624: , fnd_lookup_values fvl79
162625: , fnd_lookup_values fvl95
162626: , fnd_lookup_values fvl125
162627: , fnd_lookup_values fvl135
162628: WHERE xet.event_id between x_first_event_id and x_last_event_id
162629: and xet.event_date between p_pad_start_date and p_pad_end_date
162630: and xet.event_class_code = C_EVENT_CLASS_CODE
162631: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 165185: , fnd_lookup_values fvl15

165181: END source_meaning
165182: FROM xla_events_gt xet
165183: , AP_PAYMENT_EXTRACT_HEADER_V h2
165184: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165185: , fnd_lookup_values fvl15
165186: , fnd_lookup_values fvl19
165187: , fnd_lookup_values fvl47
165188: , fnd_lookup_values fvl113
165189: , fnd_lookup_values fvl122

Line 165186: , fnd_lookup_values fvl19

165182: FROM xla_events_gt xet
165183: , AP_PAYMENT_EXTRACT_HEADER_V h2
165184: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165185: , fnd_lookup_values fvl15
165186: , fnd_lookup_values fvl19
165187: , fnd_lookup_values fvl47
165188: , fnd_lookup_values fvl113
165189: , fnd_lookup_values fvl122
165190: ,(select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)

Line 165187: , fnd_lookup_values fvl47

165183: , AP_PAYMENT_EXTRACT_HEADER_V h2
165184: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165185: , fnd_lookup_values fvl15
165186: , fnd_lookup_values fvl19
165187: , fnd_lookup_values fvl47
165188: , fnd_lookup_values fvl113
165189: , fnd_lookup_values fvl122
165190: ,(select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
165191: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 165188: , fnd_lookup_values fvl113

165184: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165185: , fnd_lookup_values fvl15
165186: , fnd_lookup_values fvl19
165187: , fnd_lookup_values fvl47
165188: , fnd_lookup_values fvl113
165189: , fnd_lookup_values fvl122
165190: ,(select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
165191: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165192: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 165189: , fnd_lookup_values fvl122

165185: , fnd_lookup_values fvl15
165186: , fnd_lookup_values fvl19
165187: , fnd_lookup_values fvl47
165188: , fnd_lookup_values fvl113
165189: , fnd_lookup_values fvl122
165190: ,(select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
165191: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165192: AND xet.event_class_code = C_EVENT_CLASS_CODE
165193: AND h2.event_id = xet.event_id

Line 165523: , fnd_lookup_values fvl33

165519: END source_meaning
165520: FROM xla_events_gt xet
165521: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165522: , ZX_AP_DEF_TAX_EXTRACT_V l4
165523: , fnd_lookup_values fvl33
165524: , fnd_lookup_values fvl79
165525: , fnd_lookup_values fvl97
165526: , fnd_lookup_values fvl125
165527: , fnd_lookup_values fvl160

Line 165524: , fnd_lookup_values fvl79

165520: FROM xla_events_gt xet
165521: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165522: , ZX_AP_DEF_TAX_EXTRACT_V l4
165523: , fnd_lookup_values fvl33
165524: , fnd_lookup_values fvl79
165525: , fnd_lookup_values fvl97
165526: , fnd_lookup_values fvl125
165527: , fnd_lookup_values fvl160
165528: , fnd_lookup_values fvl161

Line 165525: , fnd_lookup_values fvl97

165521: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165522: , ZX_AP_DEF_TAX_EXTRACT_V l4
165523: , fnd_lookup_values fvl33
165524: , fnd_lookup_values fvl79
165525: , fnd_lookup_values fvl97
165526: , fnd_lookup_values fvl125
165527: , fnd_lookup_values fvl160
165528: , fnd_lookup_values fvl161
165529: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)

Line 165526: , fnd_lookup_values fvl125

165522: , ZX_AP_DEF_TAX_EXTRACT_V l4
165523: , fnd_lookup_values fvl33
165524: , fnd_lookup_values fvl79
165525: , fnd_lookup_values fvl97
165526: , fnd_lookup_values fvl125
165527: , fnd_lookup_values fvl160
165528: , fnd_lookup_values fvl161
165529: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
165530: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 165527: , fnd_lookup_values fvl160

165523: , fnd_lookup_values fvl33
165524: , fnd_lookup_values fvl79
165525: , fnd_lookup_values fvl97
165526: , fnd_lookup_values fvl125
165527: , fnd_lookup_values fvl160
165528: , fnd_lookup_values fvl161
165529: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
165530: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165531: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 165528: , fnd_lookup_values fvl161

165524: , fnd_lookup_values fvl79
165525: , fnd_lookup_values fvl97
165526: , fnd_lookup_values fvl125
165527: , fnd_lookup_values fvl160
165528: , fnd_lookup_values fvl161
165529: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
165530: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165531: AND xet.event_class_code = C_EVENT_CLASS_CODE
165532: AND l1.event_id = xet.event_id

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

165683: l_balance_type_code VARCHAR2(1) :=NULL;
165684: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
165685:
165686: --
165687: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
165688: --
165689:
165690: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
165691: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 165940: , fnd_lookup_values fvl15

165936: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
165937: FROM xla_events_gt xet
165938: , AP_PAYMENT_EXTRACT_HEADER_V h2
165939: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165940: , fnd_lookup_values fvl15
165941: , fnd_lookup_values fvl19
165942: , fnd_lookup_values fvl47
165943: , fnd_lookup_values fvl113
165944: , fnd_lookup_values fvl122

Line 165941: , fnd_lookup_values fvl19

165937: FROM xla_events_gt xet
165938: , AP_PAYMENT_EXTRACT_HEADER_V h2
165939: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165940: , fnd_lookup_values fvl15
165941: , fnd_lookup_values fvl19
165942: , fnd_lookup_values fvl47
165943: , fnd_lookup_values fvl113
165944: , fnd_lookup_values fvl122
165945: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 165942: , fnd_lookup_values fvl47

165938: , AP_PAYMENT_EXTRACT_HEADER_V h2
165939: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165940: , fnd_lookup_values fvl15
165941: , fnd_lookup_values fvl19
165942: , fnd_lookup_values fvl47
165943: , fnd_lookup_values fvl113
165944: , fnd_lookup_values fvl122
165945: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165946: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 165943: , fnd_lookup_values fvl113

165939: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165940: , fnd_lookup_values fvl15
165941: , fnd_lookup_values fvl19
165942: , fnd_lookup_values fvl47
165943: , fnd_lookup_values fvl113
165944: , fnd_lookup_values fvl122
165945: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165946: and xet.event_class_code = C_EVENT_CLASS_CODE
165947: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 165944: , fnd_lookup_values fvl122

165940: , fnd_lookup_values fvl15
165941: , fnd_lookup_values fvl19
165942: , fnd_lookup_values fvl47
165943: , fnd_lookup_values fvl113
165944: , fnd_lookup_values fvl122
165945: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165946: and xet.event_class_code = C_EVENT_CLASS_CODE
165947: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
165948: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 166054: , fnd_lookup_values fvl33

166050: , fvl161.meaning source_161_meaning
166051: FROM xla_events_gt xet
166052: , AP_PAYMENT_EXTRACT_DETAILS_V l1
166053: , ZX_AP_DEF_TAX_EXTRACT_V l4
166054: , fnd_lookup_values fvl33
166055: , fnd_lookup_values fvl79
166056: , fnd_lookup_values fvl97
166057: , fnd_lookup_values fvl125
166058: , fnd_lookup_values fvl160

Line 166055: , fnd_lookup_values fvl79

166051: FROM xla_events_gt xet
166052: , AP_PAYMENT_EXTRACT_DETAILS_V l1
166053: , ZX_AP_DEF_TAX_EXTRACT_V l4
166054: , fnd_lookup_values fvl33
166055: , fnd_lookup_values fvl79
166056: , fnd_lookup_values fvl97
166057: , fnd_lookup_values fvl125
166058: , fnd_lookup_values fvl160
166059: , fnd_lookup_values fvl161

Line 166056: , fnd_lookup_values fvl97

166052: , AP_PAYMENT_EXTRACT_DETAILS_V l1
166053: , ZX_AP_DEF_TAX_EXTRACT_V l4
166054: , fnd_lookup_values fvl33
166055: , fnd_lookup_values fvl79
166056: , fnd_lookup_values fvl97
166057: , fnd_lookup_values fvl125
166058: , fnd_lookup_values fvl160
166059: , fnd_lookup_values fvl161
166060: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 166057: , fnd_lookup_values fvl125

166053: , ZX_AP_DEF_TAX_EXTRACT_V l4
166054: , fnd_lookup_values fvl33
166055: , fnd_lookup_values fvl79
166056: , fnd_lookup_values fvl97
166057: , fnd_lookup_values fvl125
166058: , fnd_lookup_values fvl160
166059: , fnd_lookup_values fvl161
166060: WHERE xet.event_id between x_first_event_id and x_last_event_id
166061: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 166058: , fnd_lookup_values fvl160

166054: , fnd_lookup_values fvl33
166055: , fnd_lookup_values fvl79
166056: , fnd_lookup_values fvl97
166057: , fnd_lookup_values fvl125
166058: , fnd_lookup_values fvl160
166059: , fnd_lookup_values fvl161
166060: WHERE xet.event_id between x_first_event_id and x_last_event_id
166061: and xet.event_date between p_pad_start_date and p_pad_end_date
166062: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 166059: , fnd_lookup_values fvl161

166055: , fnd_lookup_values fvl79
166056: , fnd_lookup_values fvl97
166057: , fnd_lookup_values fvl125
166058: , fnd_lookup_values fvl160
166059: , fnd_lookup_values fvl161
166060: WHERE xet.event_id between x_first_event_id and x_last_event_id
166061: and xet.event_date between p_pad_start_date and p_pad_end_date
166062: and xet.event_class_code = C_EVENT_CLASS_CODE
166063: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 168280: , fnd_lookup_values fvl15

168276: END source_meaning
168277: FROM xla_events_gt xet
168278: , AP_PAYMENT_EXTRACT_HEADER_V h2
168279: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168280: , fnd_lookup_values fvl15
168281: , fnd_lookup_values fvl19
168282: , fnd_lookup_values fvl47
168283: , fnd_lookup_values fvl113
168284: , fnd_lookup_values fvl122

Line 168281: , fnd_lookup_values fvl19

168277: FROM xla_events_gt xet
168278: , AP_PAYMENT_EXTRACT_HEADER_V h2
168279: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168280: , fnd_lookup_values fvl15
168281: , fnd_lookup_values fvl19
168282: , fnd_lookup_values fvl47
168283: , fnd_lookup_values fvl113
168284: , fnd_lookup_values fvl122
168285: , fnd_lookup_values fvl172

Line 168282: , fnd_lookup_values fvl47

168278: , AP_PAYMENT_EXTRACT_HEADER_V h2
168279: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168280: , fnd_lookup_values fvl15
168281: , fnd_lookup_values fvl19
168282: , fnd_lookup_values fvl47
168283: , fnd_lookup_values fvl113
168284: , fnd_lookup_values fvl122
168285: , fnd_lookup_values fvl172
168286: ,(select rownum r from all_objects where rownum <= 32 and owner = p_apps_owner)

Line 168283: , fnd_lookup_values fvl113

168279: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168280: , fnd_lookup_values fvl15
168281: , fnd_lookup_values fvl19
168282: , fnd_lookup_values fvl47
168283: , fnd_lookup_values fvl113
168284: , fnd_lookup_values fvl122
168285: , fnd_lookup_values fvl172
168286: ,(select rownum r from all_objects where rownum <= 32 and owner = p_apps_owner)
168287: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 168284: , fnd_lookup_values fvl122

168280: , fnd_lookup_values fvl15
168281: , fnd_lookup_values fvl19
168282: , fnd_lookup_values fvl47
168283: , fnd_lookup_values fvl113
168284: , fnd_lookup_values fvl122
168285: , fnd_lookup_values fvl172
168286: ,(select rownum r from all_objects where rownum <= 32 and owner = p_apps_owner)
168287: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168288: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 168285: , fnd_lookup_values fvl172

168281: , fnd_lookup_values fvl19
168282: , fnd_lookup_values fvl47
168283: , fnd_lookup_values fvl113
168284: , fnd_lookup_values fvl122
168285: , fnd_lookup_values fvl172
168286: ,(select rownum r from all_objects where rownum <= 32 and owner = p_apps_owner)
168287: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168288: AND xet.event_class_code = C_EVENT_CLASS_CODE
168289: AND h2.event_id = xet.event_id

Line 168546: , fnd_lookup_values fvl33

168542: FROM xla_events_gt xet
168543: , AP_PAYMENT_EXTRACT_DETAILS_V l1
168544: , ZX_AP_DEF_TAX_EXTRACT_V l4
168545: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
168546: , fnd_lookup_values fvl33
168547: , fnd_lookup_values fvl79
168548: , fnd_lookup_values fvl97
168549: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
168550: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 168547: , fnd_lookup_values fvl79

168543: , AP_PAYMENT_EXTRACT_DETAILS_V l1
168544: , ZX_AP_DEF_TAX_EXTRACT_V l4
168545: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
168546: , fnd_lookup_values fvl33
168547: , fnd_lookup_values fvl79
168548: , fnd_lookup_values fvl97
168549: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
168550: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168551: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 168548: , fnd_lookup_values fvl97

168544: , ZX_AP_DEF_TAX_EXTRACT_V l4
168545: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
168546: , fnd_lookup_values fvl33
168547: , fnd_lookup_values fvl79
168548: , fnd_lookup_values fvl97
168549: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
168550: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168551: AND xet.event_class_code = C_EVENT_CLASS_CODE
168552: AND l1.event_id = xet.event_id

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

168691: l_balance_type_code VARCHAR2(1) :=NULL;
168692: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
168693:
168694: --
168695: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
168696: --
168697:
168698: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
168699: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 168899: , fnd_lookup_values fvl15

168895: , fvl172.meaning source_172_meaning
168896: FROM xla_events_gt xet
168897: , AP_PAYMENT_EXTRACT_HEADER_V h2
168898: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168899: , fnd_lookup_values fvl15
168900: , fnd_lookup_values fvl19
168901: , fnd_lookup_values fvl47
168902: , fnd_lookup_values fvl113
168903: , fnd_lookup_values fvl122

Line 168900: , fnd_lookup_values fvl19

168896: FROM xla_events_gt xet
168897: , AP_PAYMENT_EXTRACT_HEADER_V h2
168898: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168899: , fnd_lookup_values fvl15
168900: , fnd_lookup_values fvl19
168901: , fnd_lookup_values fvl47
168902: , fnd_lookup_values fvl113
168903: , fnd_lookup_values fvl122
168904: , fnd_lookup_values fvl172

Line 168901: , fnd_lookup_values fvl47

168897: , AP_PAYMENT_EXTRACT_HEADER_V h2
168898: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168899: , fnd_lookup_values fvl15
168900: , fnd_lookup_values fvl19
168901: , fnd_lookup_values fvl47
168902: , fnd_lookup_values fvl113
168903: , fnd_lookup_values fvl122
168904: , fnd_lookup_values fvl172
168905: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 168902: , fnd_lookup_values fvl113

168898: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168899: , fnd_lookup_values fvl15
168900: , fnd_lookup_values fvl19
168901: , fnd_lookup_values fvl47
168902: , fnd_lookup_values fvl113
168903: , fnd_lookup_values fvl122
168904: , fnd_lookup_values fvl172
168905: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
168906: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 168903: , fnd_lookup_values fvl122

168899: , fnd_lookup_values fvl15
168900: , fnd_lookup_values fvl19
168901: , fnd_lookup_values fvl47
168902: , fnd_lookup_values fvl113
168903: , fnd_lookup_values fvl122
168904: , fnd_lookup_values fvl172
168905: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
168906: and xet.event_class_code = C_EVENT_CLASS_CODE
168907: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 168904: , fnd_lookup_values fvl172

168900: , fnd_lookup_values fvl19
168901: , fnd_lookup_values fvl47
168902: , fnd_lookup_values fvl113
168903: , fnd_lookup_values fvl122
168904: , fnd_lookup_values fvl172
168905: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
168906: and xet.event_class_code = C_EVENT_CLASS_CODE
168907: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
168908: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 169001: , fnd_lookup_values fvl33

168997: FROM xla_events_gt xet
168998: , AP_PAYMENT_EXTRACT_DETAILS_V l1
168999: , ZX_AP_DEF_TAX_EXTRACT_V l4
169000: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
169001: , fnd_lookup_values fvl33
169002: , fnd_lookup_values fvl79
169003: , fnd_lookup_values fvl97
169004: WHERE xet.event_id between x_first_event_id and x_last_event_id
169005: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 169002: , fnd_lookup_values fvl79

168998: , AP_PAYMENT_EXTRACT_DETAILS_V l1
168999: , ZX_AP_DEF_TAX_EXTRACT_V l4
169000: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
169001: , fnd_lookup_values fvl33
169002: , fnd_lookup_values fvl79
169003: , fnd_lookup_values fvl97
169004: WHERE xet.event_id between x_first_event_id and x_last_event_id
169005: and xet.event_date between p_pad_start_date and p_pad_end_date
169006: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 169003: , fnd_lookup_values fvl97

168999: , ZX_AP_DEF_TAX_EXTRACT_V l4
169000: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
169001: , fnd_lookup_values fvl33
169002: , fnd_lookup_values fvl79
169003: , fnd_lookup_values fvl97
169004: WHERE xet.event_id between x_first_event_id and x_last_event_id
169005: and xet.event_date between p_pad_start_date and p_pad_end_date
169006: and xet.event_class_code = C_EVENT_CLASS_CODE
169007: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id