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

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

118919: l_balance_type_code VARCHAR2(1) :=NULL;
118920: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
118921:
118922: --
118923: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
118924: --
118925:
118926: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
118927: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

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

120176: l_balance_type_code VARCHAR2(1) :=NULL;
120177: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
120178:
120179: --
120180: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
120181: --
120182:
120183: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
120184: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 121220: , fnd_lookup_values fvl4

121216: END source_meaning
121217: FROM xla_events_gt xet
121218: , AP_PAYMENT_EXTRACT_HEADER_V h2
121219: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
121220: , fnd_lookup_values fvl4
121221: , fnd_lookup_values fvl30
121222: , fnd_lookup_values fvl110
121223: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
121224: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 121221: , fnd_lookup_values fvl30

121217: FROM xla_events_gt xet
121218: , AP_PAYMENT_EXTRACT_HEADER_V h2
121219: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
121220: , fnd_lookup_values fvl4
121221: , fnd_lookup_values fvl30
121222: , fnd_lookup_values fvl110
121223: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
121224: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
121225: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 121222: , fnd_lookup_values fvl110

121218: , AP_PAYMENT_EXTRACT_HEADER_V h2
121219: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
121220: , fnd_lookup_values fvl4
121221: , fnd_lookup_values fvl30
121222: , fnd_lookup_values fvl110
121223: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
121224: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
121225: AND xet.event_class_code = C_EVENT_CLASS_CODE
121226: AND h2.event_id = xet.event_id

Line 121418: , fnd_lookup_values fvl39

121414: ELSE null
121415: END source_meaning
121416: FROM xla_events_gt xet
121417: , AP_PAYMENT_EXTRACT_DETAILS_V l1
121418: , fnd_lookup_values fvl39
121419: , fnd_lookup_values fvl53
121420: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
121421: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
121422: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 121419: , fnd_lookup_values fvl53

121415: END source_meaning
121416: FROM xla_events_gt xet
121417: , AP_PAYMENT_EXTRACT_DETAILS_V l1
121418: , fnd_lookup_values fvl39
121419: , fnd_lookup_values fvl53
121420: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
121421: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
121422: AND xet.event_class_code = C_EVENT_CLASS_CODE
121423: AND l1.event_id = xet.event_id

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

121558: l_balance_type_code VARCHAR2(1) :=NULL;
121559: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
121560:
121561: --
121562: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
121563: --
121564:
121565: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
121566: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 121709: , fnd_lookup_values fvl4

121705: , h2.AC_DOC_SEQUENCE_VALUE source_160
121706: FROM xla_events_gt xet
121707: , AP_PAYMENT_EXTRACT_HEADER_V h2
121708: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
121709: , fnd_lookup_values fvl4
121710: , fnd_lookup_values fvl30
121711: , fnd_lookup_values fvl110
121712: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
121713: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 121710: , fnd_lookup_values fvl30

121706: FROM xla_events_gt xet
121707: , AP_PAYMENT_EXTRACT_HEADER_V h2
121708: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
121709: , fnd_lookup_values fvl4
121710: , fnd_lookup_values fvl30
121711: , fnd_lookup_values fvl110
121712: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
121713: and xet.event_class_code = C_EVENT_CLASS_CODE
121714: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 121711: , fnd_lookup_values fvl110

121707: , AP_PAYMENT_EXTRACT_HEADER_V h2
121708: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
121709: , fnd_lookup_values fvl4
121710: , fnd_lookup_values fvl30
121711: , fnd_lookup_values fvl110
121712: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
121713: and xet.event_class_code = C_EVENT_CLASS_CODE
121714: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
121715: AND h3.asp_org_id = h2.ac_org_id AND fvl4.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 121783: , fnd_lookup_values fvl39

121779: , l1.PMT_MAT_BASE_AMT_DIFF source_128
121780: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_133
121781: FROM xla_events_gt xet
121782: , AP_PAYMENT_EXTRACT_DETAILS_V l1
121783: , fnd_lookup_values fvl39
121784: , fnd_lookup_values fvl53
121785: WHERE xet.event_id between x_first_event_id and x_last_event_id
121786: and xet.event_date between p_pad_start_date and p_pad_end_date
121787: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 121784: , fnd_lookup_values fvl53

121780: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_133
121781: FROM xla_events_gt xet
121782: , AP_PAYMENT_EXTRACT_DETAILS_V l1
121783: , fnd_lookup_values fvl39
121784: , fnd_lookup_values fvl53
121785: WHERE xet.event_id between x_first_event_id and x_last_event_id
121786: and xet.event_date between p_pad_start_date and p_pad_end_date
121787: and xet.event_class_code = C_EVENT_CLASS_CODE
121788: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

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

123422: l_balance_type_code VARCHAR2(1) :=NULL;
123423: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
123424:
123425: --
123426: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
123427: --
123428:
123429: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
123430: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

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

124565: l_balance_type_code VARCHAR2(1) :=NULL;
124566: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
124567:
124568: --
124569: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
124570: --
124571:
124572:
124573: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 125649: , fnd_lookup_values fvl3

125645: END source_meaning
125646: FROM xla_events_gt xet
125647: , AP_PAYMENT_EXTRACT_HEADER_V h2
125648: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
125649: , fnd_lookup_values fvl3
125650: , fnd_lookup_values fvl4
125651: , fnd_lookup_values fvl12
125652: , fnd_lookup_values fvl18
125653: , fnd_lookup_values fvl30

Line 125650: , fnd_lookup_values fvl4

125646: FROM xla_events_gt xet
125647: , AP_PAYMENT_EXTRACT_HEADER_V h2
125648: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
125649: , fnd_lookup_values fvl3
125650: , fnd_lookup_values fvl4
125651: , fnd_lookup_values fvl12
125652: , fnd_lookup_values fvl18
125653: , fnd_lookup_values fvl30
125654: , fnd_lookup_values fvl60

Line 125651: , fnd_lookup_values fvl12

125647: , AP_PAYMENT_EXTRACT_HEADER_V h2
125648: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
125649: , fnd_lookup_values fvl3
125650: , fnd_lookup_values fvl4
125651: , fnd_lookup_values fvl12
125652: , fnd_lookup_values fvl18
125653: , fnd_lookup_values fvl30
125654: , fnd_lookup_values fvl60
125655: , fnd_lookup_values fvl102

Line 125652: , fnd_lookup_values fvl18

125648: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
125649: , fnd_lookup_values fvl3
125650: , fnd_lookup_values fvl4
125651: , fnd_lookup_values fvl12
125652: , fnd_lookup_values fvl18
125653: , fnd_lookup_values fvl30
125654: , fnd_lookup_values fvl60
125655: , fnd_lookup_values fvl102
125656: , fnd_lookup_values fvl110

Line 125653: , fnd_lookup_values fvl30

125649: , fnd_lookup_values fvl3
125650: , fnd_lookup_values fvl4
125651: , fnd_lookup_values fvl12
125652: , fnd_lookup_values fvl18
125653: , fnd_lookup_values fvl30
125654: , fnd_lookup_values fvl60
125655: , fnd_lookup_values fvl102
125656: , fnd_lookup_values fvl110
125657: , fnd_lookup_values fvl175

Line 125654: , fnd_lookup_values fvl60

125650: , fnd_lookup_values fvl4
125651: , fnd_lookup_values fvl12
125652: , fnd_lookup_values fvl18
125653: , fnd_lookup_values fvl30
125654: , fnd_lookup_values fvl60
125655: , fnd_lookup_values fvl102
125656: , fnd_lookup_values fvl110
125657: , fnd_lookup_values fvl175
125658: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)

Line 125655: , fnd_lookup_values fvl102

125651: , fnd_lookup_values fvl12
125652: , fnd_lookup_values fvl18
125653: , fnd_lookup_values fvl30
125654: , fnd_lookup_values fvl60
125655: , fnd_lookup_values fvl102
125656: , fnd_lookup_values fvl110
125657: , fnd_lookup_values fvl175
125658: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
125659: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 125656: , fnd_lookup_values fvl110

125652: , fnd_lookup_values fvl18
125653: , fnd_lookup_values fvl30
125654: , fnd_lookup_values fvl60
125655: , fnd_lookup_values fvl102
125656: , fnd_lookup_values fvl110
125657: , fnd_lookup_values fvl175
125658: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
125659: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
125660: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 125657: , fnd_lookup_values fvl175

125653: , fnd_lookup_values fvl30
125654: , fnd_lookup_values fvl60
125655: , fnd_lookup_values fvl102
125656: , fnd_lookup_values fvl110
125657: , fnd_lookup_values fvl175
125658: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
125659: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
125660: AND xet.event_class_code = C_EVENT_CLASS_CODE
125661: AND h2.event_id = xet.event_id

Line 125990: , fnd_lookup_values fvl7

125986: , AP_PAYMENT_EXTRACT_DETAILS_V l1
125987: , AP_PO_HEADERS_EXTRACT_V l3
125988: , ZX_AP_DEF_TAX_EXTRACT_V l5
125989: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
125990: , fnd_lookup_values fvl7
125991: , fnd_lookup_values fvl20
125992: , fnd_lookup_values fvl39
125993: , fnd_lookup_values fvl53
125994: , fnd_lookup_values fvl100

Line 125991: , fnd_lookup_values fvl20

125987: , AP_PO_HEADERS_EXTRACT_V l3
125988: , ZX_AP_DEF_TAX_EXTRACT_V l5
125989: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
125990: , fnd_lookup_values fvl7
125991: , fnd_lookup_values fvl20
125992: , fnd_lookup_values fvl39
125993: , fnd_lookup_values fvl53
125994: , fnd_lookup_values fvl100
125995: , fnd_lookup_values fvl101

Line 125992: , fnd_lookup_values fvl39

125988: , ZX_AP_DEF_TAX_EXTRACT_V l5
125989: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
125990: , fnd_lookup_values fvl7
125991: , fnd_lookup_values fvl20
125992: , fnd_lookup_values fvl39
125993: , fnd_lookup_values fvl53
125994: , fnd_lookup_values fvl100
125995: , fnd_lookup_values fvl101
125996: , fnd_lookup_values fvl104

Line 125993: , fnd_lookup_values fvl53

125989: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
125990: , fnd_lookup_values fvl7
125991: , fnd_lookup_values fvl20
125992: , fnd_lookup_values fvl39
125993: , fnd_lookup_values fvl53
125994: , fnd_lookup_values fvl100
125995: , fnd_lookup_values fvl101
125996: , fnd_lookup_values fvl104
125997: , (select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)

Line 125994: , fnd_lookup_values fvl100

125990: , fnd_lookup_values fvl7
125991: , fnd_lookup_values fvl20
125992: , fnd_lookup_values fvl39
125993: , fnd_lookup_values fvl53
125994: , fnd_lookup_values fvl100
125995: , fnd_lookup_values fvl101
125996: , fnd_lookup_values fvl104
125997: , (select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
125998: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 125995: , fnd_lookup_values fvl101

125991: , fnd_lookup_values fvl20
125992: , fnd_lookup_values fvl39
125993: , fnd_lookup_values fvl53
125994: , fnd_lookup_values fvl100
125995: , fnd_lookup_values fvl101
125996: , fnd_lookup_values fvl104
125997: , (select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
125998: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
125999: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 125996: , fnd_lookup_values fvl104

125992: , fnd_lookup_values fvl39
125993: , fnd_lookup_values fvl53
125994: , fnd_lookup_values fvl100
125995: , fnd_lookup_values fvl101
125996: , fnd_lookup_values fvl104
125997: , (select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
125998: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
125999: AND xet.event_class_code = C_EVENT_CLASS_CODE
126000: AND l1.event_id = xet.event_id

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

126155: l_balance_type_code VARCHAR2(1) :=NULL;
126156: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
126157:
126158: --
126159: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
126160: --
126161:
126162: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
126163: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 126404: , fnd_lookup_values fvl3

126400: , fvl175.meaning source_175_meaning
126401: FROM xla_events_gt xet
126402: , AP_PAYMENT_EXTRACT_HEADER_V h2
126403: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
126404: , fnd_lookup_values fvl3
126405: , fnd_lookup_values fvl4
126406: , fnd_lookup_values fvl12
126407: , fnd_lookup_values fvl18
126408: , fnd_lookup_values fvl30

Line 126405: , fnd_lookup_values fvl4

126401: FROM xla_events_gt xet
126402: , AP_PAYMENT_EXTRACT_HEADER_V h2
126403: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
126404: , fnd_lookup_values fvl3
126405: , fnd_lookup_values fvl4
126406: , fnd_lookup_values fvl12
126407: , fnd_lookup_values fvl18
126408: , fnd_lookup_values fvl30
126409: , fnd_lookup_values fvl60

Line 126406: , fnd_lookup_values fvl12

126402: , AP_PAYMENT_EXTRACT_HEADER_V h2
126403: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
126404: , fnd_lookup_values fvl3
126405: , fnd_lookup_values fvl4
126406: , fnd_lookup_values fvl12
126407: , fnd_lookup_values fvl18
126408: , fnd_lookup_values fvl30
126409: , fnd_lookup_values fvl60
126410: , fnd_lookup_values fvl102

Line 126407: , fnd_lookup_values fvl18

126403: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
126404: , fnd_lookup_values fvl3
126405: , fnd_lookup_values fvl4
126406: , fnd_lookup_values fvl12
126407: , fnd_lookup_values fvl18
126408: , fnd_lookup_values fvl30
126409: , fnd_lookup_values fvl60
126410: , fnd_lookup_values fvl102
126411: , fnd_lookup_values fvl110

Line 126408: , fnd_lookup_values fvl30

126404: , fnd_lookup_values fvl3
126405: , fnd_lookup_values fvl4
126406: , fnd_lookup_values fvl12
126407: , fnd_lookup_values fvl18
126408: , fnd_lookup_values fvl30
126409: , fnd_lookup_values fvl60
126410: , fnd_lookup_values fvl102
126411: , fnd_lookup_values fvl110
126412: , fnd_lookup_values fvl175

Line 126409: , fnd_lookup_values fvl60

126405: , fnd_lookup_values fvl4
126406: , fnd_lookup_values fvl12
126407: , fnd_lookup_values fvl18
126408: , fnd_lookup_values fvl30
126409: , fnd_lookup_values fvl60
126410: , fnd_lookup_values fvl102
126411: , fnd_lookup_values fvl110
126412: , fnd_lookup_values fvl175
126413: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 126410: , fnd_lookup_values fvl102

126406: , fnd_lookup_values fvl12
126407: , fnd_lookup_values fvl18
126408: , fnd_lookup_values fvl30
126409: , fnd_lookup_values fvl60
126410: , fnd_lookup_values fvl102
126411: , fnd_lookup_values fvl110
126412: , fnd_lookup_values fvl175
126413: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
126414: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 126411: , fnd_lookup_values fvl110

126407: , fnd_lookup_values fvl18
126408: , fnd_lookup_values fvl30
126409: , fnd_lookup_values fvl60
126410: , fnd_lookup_values fvl102
126411: , fnd_lookup_values fvl110
126412: , fnd_lookup_values fvl175
126413: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
126414: and xet.event_class_code = C_EVENT_CLASS_CODE
126415: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 126412: , fnd_lookup_values fvl175

126408: , fnd_lookup_values fvl30
126409: , fnd_lookup_values fvl60
126410: , fnd_lookup_values fvl102
126411: , fnd_lookup_values fvl110
126412: , fnd_lookup_values fvl175
126413: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
126414: and xet.event_class_code = C_EVENT_CLASS_CODE
126415: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
126416: AND h4.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'

Line 126537: , fnd_lookup_values fvl7

126533: , AP_PAYMENT_EXTRACT_DETAILS_V l1
126534: , AP_PO_HEADERS_EXTRACT_V l3
126535: , ZX_AP_DEF_TAX_EXTRACT_V l5
126536: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
126537: , fnd_lookup_values fvl7
126538: , fnd_lookup_values fvl20
126539: , fnd_lookup_values fvl39
126540: , fnd_lookup_values fvl53
126541: , fnd_lookup_values fvl100

Line 126538: , fnd_lookup_values fvl20

126534: , AP_PO_HEADERS_EXTRACT_V l3
126535: , ZX_AP_DEF_TAX_EXTRACT_V l5
126536: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
126537: , fnd_lookup_values fvl7
126538: , fnd_lookup_values fvl20
126539: , fnd_lookup_values fvl39
126540: , fnd_lookup_values fvl53
126541: , fnd_lookup_values fvl100
126542: , fnd_lookup_values fvl101

Line 126539: , fnd_lookup_values fvl39

126535: , ZX_AP_DEF_TAX_EXTRACT_V l5
126536: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
126537: , fnd_lookup_values fvl7
126538: , fnd_lookup_values fvl20
126539: , fnd_lookup_values fvl39
126540: , fnd_lookup_values fvl53
126541: , fnd_lookup_values fvl100
126542: , fnd_lookup_values fvl101
126543: , fnd_lookup_values fvl104

Line 126540: , fnd_lookup_values fvl53

126536: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
126537: , fnd_lookup_values fvl7
126538: , fnd_lookup_values fvl20
126539: , fnd_lookup_values fvl39
126540: , fnd_lookup_values fvl53
126541: , fnd_lookup_values fvl100
126542: , fnd_lookup_values fvl101
126543: , fnd_lookup_values fvl104
126544: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 126541: , fnd_lookup_values fvl100

126537: , fnd_lookup_values fvl7
126538: , fnd_lookup_values fvl20
126539: , fnd_lookup_values fvl39
126540: , fnd_lookup_values fvl53
126541: , fnd_lookup_values fvl100
126542: , fnd_lookup_values fvl101
126543: , fnd_lookup_values fvl104
126544: WHERE xet.event_id between x_first_event_id and x_last_event_id
126545: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 126542: , fnd_lookup_values fvl101

126538: , fnd_lookup_values fvl20
126539: , fnd_lookup_values fvl39
126540: , fnd_lookup_values fvl53
126541: , fnd_lookup_values fvl100
126542: , fnd_lookup_values fvl101
126543: , fnd_lookup_values fvl104
126544: WHERE xet.event_id between x_first_event_id and x_last_event_id
126545: and xet.event_date between p_pad_start_date and p_pad_end_date
126546: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 126543: , fnd_lookup_values fvl104

126539: , fnd_lookup_values fvl39
126540: , fnd_lookup_values fvl53
126541: , fnd_lookup_values fvl100
126542: , fnd_lookup_values fvl101
126543: , fnd_lookup_values fvl104
126544: WHERE xet.event_id between x_first_event_id and x_last_event_id
126545: and xet.event_date between p_pad_start_date and p_pad_end_date
126546: and xet.event_class_code = C_EVENT_CLASS_CODE
126547: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 129658: , fnd_lookup_values fvl4

129654: END source_meaning
129655: FROM xla_events_gt xet
129656: , AP_INVOICE_EXTRACT_HEADER_V h1
129657: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
129658: , fnd_lookup_values fvl4
129659: , fnd_lookup_values fvl30
129660: , fnd_lookup_values fvl102
129661: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
129662: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 129659: , fnd_lookup_values fvl30

129655: FROM xla_events_gt xet
129656: , AP_INVOICE_EXTRACT_HEADER_V h1
129657: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
129658: , fnd_lookup_values fvl4
129659: , fnd_lookup_values fvl30
129660: , fnd_lookup_values fvl102
129661: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
129662: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
129663: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 129660: , fnd_lookup_values fvl102

129656: , AP_INVOICE_EXTRACT_HEADER_V h1
129657: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
129658: , fnd_lookup_values fvl4
129659: , fnd_lookup_values fvl30
129660: , fnd_lookup_values fvl102
129661: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
129662: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
129663: AND xet.event_class_code = C_EVENT_CLASS_CODE
129664: AND h1.event_id = xet.event_id

Line 130093: , fnd_lookup_values fvl7

130089: , AP_PO_HEADERS_EXTRACT_V l2
130090: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
130091: , ZX_AP_DEF_TAX_EXTRACT_V l5
130092: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
130093: , fnd_lookup_values fvl7
130094: , fnd_lookup_values fvl53
130095: , fnd_lookup_values fvl68
130096: , fnd_lookup_values fvl100
130097: , fnd_lookup_values fvl104

Line 130094: , fnd_lookup_values fvl53

130090: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
130091: , ZX_AP_DEF_TAX_EXTRACT_V l5
130092: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
130093: , fnd_lookup_values fvl7
130094: , fnd_lookup_values fvl53
130095: , fnd_lookup_values fvl68
130096: , fnd_lookup_values fvl100
130097: , fnd_lookup_values fvl104
130098: , fnd_lookup_values fvl144

Line 130095: , fnd_lookup_values fvl68

130091: , ZX_AP_DEF_TAX_EXTRACT_V l5
130092: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
130093: , fnd_lookup_values fvl7
130094: , fnd_lookup_values fvl53
130095: , fnd_lookup_values fvl68
130096: , fnd_lookup_values fvl100
130097: , fnd_lookup_values fvl104
130098: , fnd_lookup_values fvl144
130099: , (select rownum r from all_objects where rownum <= 63 and owner = p_apps_owner)

Line 130096: , fnd_lookup_values fvl100

130092: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
130093: , fnd_lookup_values fvl7
130094: , fnd_lookup_values fvl53
130095: , fnd_lookup_values fvl68
130096: , fnd_lookup_values fvl100
130097: , fnd_lookup_values fvl104
130098: , fnd_lookup_values fvl144
130099: , (select rownum r from all_objects where rownum <= 63 and owner = p_apps_owner)
130100: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 130097: , fnd_lookup_values fvl104

130093: , fnd_lookup_values fvl7
130094: , fnd_lookup_values fvl53
130095: , fnd_lookup_values fvl68
130096: , fnd_lookup_values fvl100
130097: , fnd_lookup_values fvl104
130098: , fnd_lookup_values fvl144
130099: , (select rownum r from all_objects where rownum <= 63 and owner = p_apps_owner)
130100: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
130101: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 130098: , fnd_lookup_values fvl144

130094: , fnd_lookup_values fvl53
130095: , fnd_lookup_values fvl68
130096: , fnd_lookup_values fvl100
130097: , fnd_lookup_values fvl104
130098: , fnd_lookup_values fvl144
130099: , (select rownum r from all_objects where rownum <= 63 and owner = p_apps_owner)
130100: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
130101: AND xet.event_class_code = C_EVENT_CLASS_CODE
130102: AND l3.event_id = xet.event_id

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

130253: l_balance_type_code VARCHAR2(1) :=NULL;
130254: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
130255:
130256: --
130257: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
130258: --
130259:
130260: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
130261: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 130491: , fnd_lookup_values fvl4

130487: , h1.INV_DOC_SEQUENCE_VALUE source_154
130488: FROM xla_events_gt xet
130489: , AP_INVOICE_EXTRACT_HEADER_V h1
130490: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
130491: , fnd_lookup_values fvl4
130492: , fnd_lookup_values fvl30
130493: , fnd_lookup_values fvl102
130494: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
130495: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 130492: , fnd_lookup_values fvl30

130488: FROM xla_events_gt xet
130489: , AP_INVOICE_EXTRACT_HEADER_V h1
130490: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
130491: , fnd_lookup_values fvl4
130492: , fnd_lookup_values fvl30
130493: , fnd_lookup_values fvl102
130494: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
130495: and xet.event_class_code = C_EVENT_CLASS_CODE
130496: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 130493: , fnd_lookup_values fvl102

130489: , AP_INVOICE_EXTRACT_HEADER_V h1
130490: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
130491: , fnd_lookup_values fvl4
130492: , fnd_lookup_values fvl30
130493: , fnd_lookup_values fvl102
130494: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
130495: and xet.event_class_code = C_EVENT_CLASS_CODE
130496: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
130497: AND h4.asp_org_id = h1.ai_org_id AND fvl4.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 130618: , fnd_lookup_values fvl7

130614: , AP_PO_HEADERS_EXTRACT_V l2
130615: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
130616: , ZX_AP_DEF_TAX_EXTRACT_V l5
130617: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
130618: , fnd_lookup_values fvl7
130619: , fnd_lookup_values fvl53
130620: , fnd_lookup_values fvl68
130621: , fnd_lookup_values fvl100
130622: , fnd_lookup_values fvl104

Line 130619: , fnd_lookup_values fvl53

130615: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
130616: , ZX_AP_DEF_TAX_EXTRACT_V l5
130617: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
130618: , fnd_lookup_values fvl7
130619: , fnd_lookup_values fvl53
130620: , fnd_lookup_values fvl68
130621: , fnd_lookup_values fvl100
130622: , fnd_lookup_values fvl104
130623: , fnd_lookup_values fvl144

Line 130620: , fnd_lookup_values fvl68

130616: , ZX_AP_DEF_TAX_EXTRACT_V l5
130617: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
130618: , fnd_lookup_values fvl7
130619: , fnd_lookup_values fvl53
130620: , fnd_lookup_values fvl68
130621: , fnd_lookup_values fvl100
130622: , fnd_lookup_values fvl104
130623: , fnd_lookup_values fvl144
130624: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 130621: , fnd_lookup_values fvl100

130617: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
130618: , fnd_lookup_values fvl7
130619: , fnd_lookup_values fvl53
130620: , fnd_lookup_values fvl68
130621: , fnd_lookup_values fvl100
130622: , fnd_lookup_values fvl104
130623: , fnd_lookup_values fvl144
130624: WHERE xet.event_id between x_first_event_id and x_last_event_id
130625: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 130622: , fnd_lookup_values fvl104

130618: , fnd_lookup_values fvl7
130619: , fnd_lookup_values fvl53
130620: , fnd_lookup_values fvl68
130621: , fnd_lookup_values fvl100
130622: , fnd_lookup_values fvl104
130623: , fnd_lookup_values fvl144
130624: WHERE xet.event_id between x_first_event_id and x_last_event_id
130625: and xet.event_date between p_pad_start_date and p_pad_end_date
130626: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 130623: , fnd_lookup_values fvl144

130619: , fnd_lookup_values fvl53
130620: , fnd_lookup_values fvl68
130621: , fnd_lookup_values fvl100
130622: , fnd_lookup_values fvl104
130623: , fnd_lookup_values fvl144
130624: WHERE xet.event_id between x_first_event_id and x_last_event_id
130625: and xet.event_date between p_pad_start_date and p_pad_end_date
130626: and xet.event_class_code = C_EVENT_CLASS_CODE
130627: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

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

134077: l_balance_type_code VARCHAR2(1) :=NULL;
134078: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
134079:
134080: --
134081: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
134082: --
134083:
134084: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
134085: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

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

135220: l_balance_type_code VARCHAR2(1) :=NULL;
135221: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
135222:
135223: --
135224: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
135225: --
135226:
135227:
135228: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

136332: l_balance_type_code VARCHAR2(1) :=NULL;
136333: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
136334:
136335: --
136336: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
136337: --
136338:
136339:
136340: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 137423: , fnd_lookup_values fvl3

137419: END source_meaning
137420: FROM xla_events_gt xet
137421: , AP_PAYMENT_EXTRACT_HEADER_V h2
137422: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
137423: , fnd_lookup_values fvl3
137424: , fnd_lookup_values fvl4
137425: , fnd_lookup_values fvl30
137426: , fnd_lookup_values fvl60
137427: , fnd_lookup_values fvl102

Line 137424: , fnd_lookup_values fvl4

137420: FROM xla_events_gt xet
137421: , AP_PAYMENT_EXTRACT_HEADER_V h2
137422: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
137423: , fnd_lookup_values fvl3
137424: , fnd_lookup_values fvl4
137425: , fnd_lookup_values fvl30
137426: , fnd_lookup_values fvl60
137427: , fnd_lookup_values fvl102
137428: , fnd_lookup_values fvl110

Line 137425: , fnd_lookup_values fvl30

137421: , AP_PAYMENT_EXTRACT_HEADER_V h2
137422: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
137423: , fnd_lookup_values fvl3
137424: , fnd_lookup_values fvl4
137425: , fnd_lookup_values fvl30
137426: , fnd_lookup_values fvl60
137427: , fnd_lookup_values fvl102
137428: , fnd_lookup_values fvl110
137429: ,(select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)

Line 137426: , fnd_lookup_values fvl60

137422: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
137423: , fnd_lookup_values fvl3
137424: , fnd_lookup_values fvl4
137425: , fnd_lookup_values fvl30
137426: , fnd_lookup_values fvl60
137427: , fnd_lookup_values fvl102
137428: , fnd_lookup_values fvl110
137429: ,(select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)
137430: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 137427: , fnd_lookup_values fvl102

137423: , fnd_lookup_values fvl3
137424: , fnd_lookup_values fvl4
137425: , fnd_lookup_values fvl30
137426: , fnd_lookup_values fvl60
137427: , fnd_lookup_values fvl102
137428: , fnd_lookup_values fvl110
137429: ,(select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)
137430: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
137431: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 137428: , fnd_lookup_values fvl110

137424: , fnd_lookup_values fvl4
137425: , fnd_lookup_values fvl30
137426: , fnd_lookup_values fvl60
137427: , fnd_lookup_values fvl102
137428: , fnd_lookup_values fvl110
137429: ,(select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)
137430: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
137431: AND xet.event_class_code = C_EVENT_CLASS_CODE
137432: AND h2.event_id = xet.event_id

Line 137789: , fnd_lookup_values fvl7

137785: FROM xla_events_gt xet
137786: , AP_PAYMENT_EXTRACT_DETAILS_V l1
137787: , AP_PO_HEADERS_EXTRACT_V l3
137788: , ZX_AP_DEF_TAX_EXTRACT_V l5
137789: , fnd_lookup_values fvl7
137790: , fnd_lookup_values fvl20
137791: , fnd_lookup_values fvl39
137792: , fnd_lookup_values fvl53
137793: , fnd_lookup_values fvl100

Line 137790: , fnd_lookup_values fvl20

137786: , AP_PAYMENT_EXTRACT_DETAILS_V l1
137787: , AP_PO_HEADERS_EXTRACT_V l3
137788: , ZX_AP_DEF_TAX_EXTRACT_V l5
137789: , fnd_lookup_values fvl7
137790: , fnd_lookup_values fvl20
137791: , fnd_lookup_values fvl39
137792: , fnd_lookup_values fvl53
137793: , fnd_lookup_values fvl100
137794: , fnd_lookup_values fvl101

Line 137791: , fnd_lookup_values fvl39

137787: , AP_PO_HEADERS_EXTRACT_V l3
137788: , ZX_AP_DEF_TAX_EXTRACT_V l5
137789: , fnd_lookup_values fvl7
137790: , fnd_lookup_values fvl20
137791: , fnd_lookup_values fvl39
137792: , fnd_lookup_values fvl53
137793: , fnd_lookup_values fvl100
137794: , fnd_lookup_values fvl101
137795: , fnd_lookup_values fvl104

Line 137792: , fnd_lookup_values fvl53

137788: , ZX_AP_DEF_TAX_EXTRACT_V l5
137789: , fnd_lookup_values fvl7
137790: , fnd_lookup_values fvl20
137791: , fnd_lookup_values fvl39
137792: , fnd_lookup_values fvl53
137793: , fnd_lookup_values fvl100
137794: , fnd_lookup_values fvl101
137795: , fnd_lookup_values fvl104
137796: , fnd_lookup_values fvl151

Line 137793: , fnd_lookup_values fvl100

137789: , fnd_lookup_values fvl7
137790: , fnd_lookup_values fvl20
137791: , fnd_lookup_values fvl39
137792: , fnd_lookup_values fvl53
137793: , fnd_lookup_values fvl100
137794: , fnd_lookup_values fvl101
137795: , fnd_lookup_values fvl104
137796: , fnd_lookup_values fvl151
137797: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)

Line 137794: , fnd_lookup_values fvl101

137790: , fnd_lookup_values fvl20
137791: , fnd_lookup_values fvl39
137792: , fnd_lookup_values fvl53
137793: , fnd_lookup_values fvl100
137794: , fnd_lookup_values fvl101
137795: , fnd_lookup_values fvl104
137796: , fnd_lookup_values fvl151
137797: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
137798: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 137795: , fnd_lookup_values fvl104

137791: , fnd_lookup_values fvl39
137792: , fnd_lookup_values fvl53
137793: , fnd_lookup_values fvl100
137794: , fnd_lookup_values fvl101
137795: , fnd_lookup_values fvl104
137796: , fnd_lookup_values fvl151
137797: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
137798: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
137799: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 137796: , fnd_lookup_values fvl151

137792: , fnd_lookup_values fvl53
137793: , fnd_lookup_values fvl100
137794: , fnd_lookup_values fvl101
137795: , fnd_lookup_values fvl104
137796: , fnd_lookup_values fvl151
137797: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
137798: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
137799: AND xet.event_class_code = C_EVENT_CLASS_CODE
137800: AND l1.event_id = xet.event_id

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

137959: l_balance_type_code VARCHAR2(1) :=NULL;
137960: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
137961:
137962: --
137963: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
137964: --
137965:
137966: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
137967: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 138225: , fnd_lookup_values fvl3

138221: , h2.AC_DOC_SEQUENCE_VALUE source_160
138222: FROM xla_events_gt xet
138223: , AP_PAYMENT_EXTRACT_HEADER_V h2
138224: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
138225: , fnd_lookup_values fvl3
138226: , fnd_lookup_values fvl4
138227: , fnd_lookup_values fvl30
138228: , fnd_lookup_values fvl60
138229: , fnd_lookup_values fvl102

Line 138226: , fnd_lookup_values fvl4

138222: FROM xla_events_gt xet
138223: , AP_PAYMENT_EXTRACT_HEADER_V h2
138224: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
138225: , fnd_lookup_values fvl3
138226: , fnd_lookup_values fvl4
138227: , fnd_lookup_values fvl30
138228: , fnd_lookup_values fvl60
138229: , fnd_lookup_values fvl102
138230: , fnd_lookup_values fvl110

Line 138227: , fnd_lookup_values fvl30

138223: , AP_PAYMENT_EXTRACT_HEADER_V h2
138224: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
138225: , fnd_lookup_values fvl3
138226: , fnd_lookup_values fvl4
138227: , fnd_lookup_values fvl30
138228: , fnd_lookup_values fvl60
138229: , fnd_lookup_values fvl102
138230: , fnd_lookup_values fvl110
138231: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 138228: , fnd_lookup_values fvl60

138224: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
138225: , fnd_lookup_values fvl3
138226: , fnd_lookup_values fvl4
138227: , fnd_lookup_values fvl30
138228: , fnd_lookup_values fvl60
138229: , fnd_lookup_values fvl102
138230: , fnd_lookup_values fvl110
138231: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
138232: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 138229: , fnd_lookup_values fvl102

138225: , fnd_lookup_values fvl3
138226: , fnd_lookup_values fvl4
138227: , fnd_lookup_values fvl30
138228: , fnd_lookup_values fvl60
138229: , fnd_lookup_values fvl102
138230: , fnd_lookup_values fvl110
138231: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
138232: and xet.event_class_code = C_EVENT_CLASS_CODE
138233: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 138230: , fnd_lookup_values fvl110

138226: , fnd_lookup_values fvl4
138227: , fnd_lookup_values fvl30
138228: , fnd_lookup_values fvl60
138229: , fnd_lookup_values fvl102
138230: , fnd_lookup_values fvl110
138231: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
138232: and xet.event_class_code = C_EVENT_CLASS_CODE
138233: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
138234: AND h4.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'

Line 138351: , fnd_lookup_values fvl7

138347: FROM xla_events_gt xet
138348: , AP_PAYMENT_EXTRACT_DETAILS_V l1
138349: , AP_PO_HEADERS_EXTRACT_V l3
138350: , ZX_AP_DEF_TAX_EXTRACT_V l5
138351: , fnd_lookup_values fvl7
138352: , fnd_lookup_values fvl20
138353: , fnd_lookup_values fvl39
138354: , fnd_lookup_values fvl53
138355: , fnd_lookup_values fvl100

Line 138352: , fnd_lookup_values fvl20

138348: , AP_PAYMENT_EXTRACT_DETAILS_V l1
138349: , AP_PO_HEADERS_EXTRACT_V l3
138350: , ZX_AP_DEF_TAX_EXTRACT_V l5
138351: , fnd_lookup_values fvl7
138352: , fnd_lookup_values fvl20
138353: , fnd_lookup_values fvl39
138354: , fnd_lookup_values fvl53
138355: , fnd_lookup_values fvl100
138356: , fnd_lookup_values fvl101

Line 138353: , fnd_lookup_values fvl39

138349: , AP_PO_HEADERS_EXTRACT_V l3
138350: , ZX_AP_DEF_TAX_EXTRACT_V l5
138351: , fnd_lookup_values fvl7
138352: , fnd_lookup_values fvl20
138353: , fnd_lookup_values fvl39
138354: , fnd_lookup_values fvl53
138355: , fnd_lookup_values fvl100
138356: , fnd_lookup_values fvl101
138357: , fnd_lookup_values fvl104

Line 138354: , fnd_lookup_values fvl53

138350: , ZX_AP_DEF_TAX_EXTRACT_V l5
138351: , fnd_lookup_values fvl7
138352: , fnd_lookup_values fvl20
138353: , fnd_lookup_values fvl39
138354: , fnd_lookup_values fvl53
138355: , fnd_lookup_values fvl100
138356: , fnd_lookup_values fvl101
138357: , fnd_lookup_values fvl104
138358: , fnd_lookup_values fvl151

Line 138355: , fnd_lookup_values fvl100

138351: , fnd_lookup_values fvl7
138352: , fnd_lookup_values fvl20
138353: , fnd_lookup_values fvl39
138354: , fnd_lookup_values fvl53
138355: , fnd_lookup_values fvl100
138356: , fnd_lookup_values fvl101
138357: , fnd_lookup_values fvl104
138358: , fnd_lookup_values fvl151
138359: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 138356: , fnd_lookup_values fvl101

138352: , fnd_lookup_values fvl20
138353: , fnd_lookup_values fvl39
138354: , fnd_lookup_values fvl53
138355: , fnd_lookup_values fvl100
138356: , fnd_lookup_values fvl101
138357: , fnd_lookup_values fvl104
138358: , fnd_lookup_values fvl151
138359: WHERE xet.event_id between x_first_event_id and x_last_event_id
138360: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 138357: , fnd_lookup_values fvl104

138353: , fnd_lookup_values fvl39
138354: , fnd_lookup_values fvl53
138355: , fnd_lookup_values fvl100
138356: , fnd_lookup_values fvl101
138357: , fnd_lookup_values fvl104
138358: , fnd_lookup_values fvl151
138359: WHERE xet.event_id between x_first_event_id and x_last_event_id
138360: and xet.event_date between p_pad_start_date and p_pad_end_date
138361: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 138358: , fnd_lookup_values fvl151

138354: , fnd_lookup_values fvl53
138355: , fnd_lookup_values fvl100
138356: , fnd_lookup_values fvl101
138357: , fnd_lookup_values fvl104
138358: , fnd_lookup_values fvl151
138359: WHERE xet.event_id between x_first_event_id and x_last_event_id
138360: and xet.event_date between p_pad_start_date and p_pad_end_date
138361: and xet.event_class_code = C_EVENT_CLASS_CODE
138362: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 141571: , fnd_lookup_values fvl3

141567: END source_meaning
141568: FROM xla_events_gt xet
141569: , AP_PAYMENT_EXTRACT_HEADER_V h2
141570: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
141571: , fnd_lookup_values fvl3
141572: , fnd_lookup_values fvl4
141573: , fnd_lookup_values fvl30
141574: , fnd_lookup_values fvl60
141575: , fnd_lookup_values fvl102

Line 141572: , fnd_lookup_values fvl4

141568: FROM xla_events_gt xet
141569: , AP_PAYMENT_EXTRACT_HEADER_V h2
141570: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
141571: , fnd_lookup_values fvl3
141572: , fnd_lookup_values fvl4
141573: , fnd_lookup_values fvl30
141574: , fnd_lookup_values fvl60
141575: , fnd_lookup_values fvl102
141576: , fnd_lookup_values fvl110

Line 141573: , fnd_lookup_values fvl30

141569: , AP_PAYMENT_EXTRACT_HEADER_V h2
141570: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
141571: , fnd_lookup_values fvl3
141572: , fnd_lookup_values fvl4
141573: , fnd_lookup_values fvl30
141574: , fnd_lookup_values fvl60
141575: , fnd_lookup_values fvl102
141576: , fnd_lookup_values fvl110
141577: , fnd_lookup_values fvl175

Line 141574: , fnd_lookup_values fvl60

141570: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
141571: , fnd_lookup_values fvl3
141572: , fnd_lookup_values fvl4
141573: , fnd_lookup_values fvl30
141574: , fnd_lookup_values fvl60
141575: , fnd_lookup_values fvl102
141576: , fnd_lookup_values fvl110
141577: , fnd_lookup_values fvl175
141578: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

Line 141575: , fnd_lookup_values fvl102

141571: , fnd_lookup_values fvl3
141572: , fnd_lookup_values fvl4
141573: , fnd_lookup_values fvl30
141574: , fnd_lookup_values fvl60
141575: , fnd_lookup_values fvl102
141576: , fnd_lookup_values fvl110
141577: , fnd_lookup_values fvl175
141578: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
141579: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 141576: , fnd_lookup_values fvl110

141572: , fnd_lookup_values fvl4
141573: , fnd_lookup_values fvl30
141574: , fnd_lookup_values fvl60
141575: , fnd_lookup_values fvl102
141576: , fnd_lookup_values fvl110
141577: , fnd_lookup_values fvl175
141578: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
141579: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
141580: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 141577: , fnd_lookup_values fvl175

141573: , fnd_lookup_values fvl30
141574: , fnd_lookup_values fvl60
141575: , fnd_lookup_values fvl102
141576: , fnd_lookup_values fvl110
141577: , fnd_lookup_values fvl175
141578: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
141579: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
141580: AND xet.event_class_code = C_EVENT_CLASS_CODE
141581: AND h2.event_id = xet.event_id

Line 141852: , fnd_lookup_values fvl7

141848: , AP_PAYMENT_EXTRACT_DETAILS_V l1
141849: , AP_PO_HEADERS_EXTRACT_V l3
141850: , ZX_AP_DEF_TAX_EXTRACT_V l5
141851: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
141852: , fnd_lookup_values fvl7
141853: , fnd_lookup_values fvl20
141854: , fnd_lookup_values fvl39
141855: , fnd_lookup_values fvl53
141856: , fnd_lookup_values fvl100

Line 141853: , fnd_lookup_values fvl20

141849: , AP_PO_HEADERS_EXTRACT_V l3
141850: , ZX_AP_DEF_TAX_EXTRACT_V l5
141851: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
141852: , fnd_lookup_values fvl7
141853: , fnd_lookup_values fvl20
141854: , fnd_lookup_values fvl39
141855: , fnd_lookup_values fvl53
141856: , fnd_lookup_values fvl100
141857: , fnd_lookup_values fvl101

Line 141854: , fnd_lookup_values fvl39

141850: , ZX_AP_DEF_TAX_EXTRACT_V l5
141851: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
141852: , fnd_lookup_values fvl7
141853: , fnd_lookup_values fvl20
141854: , fnd_lookup_values fvl39
141855: , fnd_lookup_values fvl53
141856: , fnd_lookup_values fvl100
141857: , fnd_lookup_values fvl101
141858: , fnd_lookup_values fvl104

Line 141855: , fnd_lookup_values fvl53

141851: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
141852: , fnd_lookup_values fvl7
141853: , fnd_lookup_values fvl20
141854: , fnd_lookup_values fvl39
141855: , fnd_lookup_values fvl53
141856: , fnd_lookup_values fvl100
141857: , fnd_lookup_values fvl101
141858: , fnd_lookup_values fvl104
141859: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)

Line 141856: , fnd_lookup_values fvl100

141852: , fnd_lookup_values fvl7
141853: , fnd_lookup_values fvl20
141854: , fnd_lookup_values fvl39
141855: , fnd_lookup_values fvl53
141856: , fnd_lookup_values fvl100
141857: , fnd_lookup_values fvl101
141858: , fnd_lookup_values fvl104
141859: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
141860: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 141857: , fnd_lookup_values fvl101

141853: , fnd_lookup_values fvl20
141854: , fnd_lookup_values fvl39
141855: , fnd_lookup_values fvl53
141856: , fnd_lookup_values fvl100
141857: , fnd_lookup_values fvl101
141858: , fnd_lookup_values fvl104
141859: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
141860: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
141861: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 141858: , fnd_lookup_values fvl104

141854: , fnd_lookup_values fvl39
141855: , fnd_lookup_values fvl53
141856: , fnd_lookup_values fvl100
141857: , fnd_lookup_values fvl101
141858: , fnd_lookup_values fvl104
141859: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
141860: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
141861: AND xet.event_class_code = C_EVENT_CLASS_CODE
141862: AND l1.event_id = xet.event_id

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

142017: l_balance_type_code VARCHAR2(1) :=NULL;
142018: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
142019:
142020: --
142021: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
142022: --
142023:
142024: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
142025: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 142212: , fnd_lookup_values fvl3

142208: , fvl175.meaning source_175_meaning
142209: FROM xla_events_gt xet
142210: , AP_PAYMENT_EXTRACT_HEADER_V h2
142211: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
142212: , fnd_lookup_values fvl3
142213: , fnd_lookup_values fvl4
142214: , fnd_lookup_values fvl30
142215: , fnd_lookup_values fvl60
142216: , fnd_lookup_values fvl102

Line 142213: , fnd_lookup_values fvl4

142209: FROM xla_events_gt xet
142210: , AP_PAYMENT_EXTRACT_HEADER_V h2
142211: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
142212: , fnd_lookup_values fvl3
142213: , fnd_lookup_values fvl4
142214: , fnd_lookup_values fvl30
142215: , fnd_lookup_values fvl60
142216: , fnd_lookup_values fvl102
142217: , fnd_lookup_values fvl110

Line 142214: , fnd_lookup_values fvl30

142210: , AP_PAYMENT_EXTRACT_HEADER_V h2
142211: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
142212: , fnd_lookup_values fvl3
142213: , fnd_lookup_values fvl4
142214: , fnd_lookup_values fvl30
142215: , fnd_lookup_values fvl60
142216: , fnd_lookup_values fvl102
142217: , fnd_lookup_values fvl110
142218: , fnd_lookup_values fvl175

Line 142215: , fnd_lookup_values fvl60

142211: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
142212: , fnd_lookup_values fvl3
142213: , fnd_lookup_values fvl4
142214: , fnd_lookup_values fvl30
142215: , fnd_lookup_values fvl60
142216: , fnd_lookup_values fvl102
142217: , fnd_lookup_values fvl110
142218: , fnd_lookup_values fvl175
142219: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 142216: , fnd_lookup_values fvl102

142212: , fnd_lookup_values fvl3
142213: , fnd_lookup_values fvl4
142214: , fnd_lookup_values fvl30
142215: , fnd_lookup_values fvl60
142216: , fnd_lookup_values fvl102
142217: , fnd_lookup_values fvl110
142218: , fnd_lookup_values fvl175
142219: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
142220: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 142217: , fnd_lookup_values fvl110

142213: , fnd_lookup_values fvl4
142214: , fnd_lookup_values fvl30
142215: , fnd_lookup_values fvl60
142216: , fnd_lookup_values fvl102
142217: , fnd_lookup_values fvl110
142218: , fnd_lookup_values fvl175
142219: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
142220: and xet.event_class_code = C_EVENT_CLASS_CODE
142221: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 142218: , fnd_lookup_values fvl175

142214: , fnd_lookup_values fvl30
142215: , fnd_lookup_values fvl60
142216: , fnd_lookup_values fvl102
142217: , fnd_lookup_values fvl110
142218: , fnd_lookup_values fvl175
142219: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
142220: and xet.event_class_code = C_EVENT_CLASS_CODE
142221: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
142222: AND h4.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'

Line 142325: , fnd_lookup_values fvl7

142321: , AP_PAYMENT_EXTRACT_DETAILS_V l1
142322: , AP_PO_HEADERS_EXTRACT_V l3
142323: , ZX_AP_DEF_TAX_EXTRACT_V l5
142324: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
142325: , fnd_lookup_values fvl7
142326: , fnd_lookup_values fvl20
142327: , fnd_lookup_values fvl39
142328: , fnd_lookup_values fvl53
142329: , fnd_lookup_values fvl100

Line 142326: , fnd_lookup_values fvl20

142322: , AP_PO_HEADERS_EXTRACT_V l3
142323: , ZX_AP_DEF_TAX_EXTRACT_V l5
142324: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
142325: , fnd_lookup_values fvl7
142326: , fnd_lookup_values fvl20
142327: , fnd_lookup_values fvl39
142328: , fnd_lookup_values fvl53
142329: , fnd_lookup_values fvl100
142330: , fnd_lookup_values fvl101

Line 142327: , fnd_lookup_values fvl39

142323: , ZX_AP_DEF_TAX_EXTRACT_V l5
142324: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
142325: , fnd_lookup_values fvl7
142326: , fnd_lookup_values fvl20
142327: , fnd_lookup_values fvl39
142328: , fnd_lookup_values fvl53
142329: , fnd_lookup_values fvl100
142330: , fnd_lookup_values fvl101
142331: , fnd_lookup_values fvl104

Line 142328: , fnd_lookup_values fvl53

142324: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
142325: , fnd_lookup_values fvl7
142326: , fnd_lookup_values fvl20
142327: , fnd_lookup_values fvl39
142328: , fnd_lookup_values fvl53
142329: , fnd_lookup_values fvl100
142330: , fnd_lookup_values fvl101
142331: , fnd_lookup_values fvl104
142332: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 142329: , fnd_lookup_values fvl100

142325: , fnd_lookup_values fvl7
142326: , fnd_lookup_values fvl20
142327: , fnd_lookup_values fvl39
142328: , fnd_lookup_values fvl53
142329: , fnd_lookup_values fvl100
142330: , fnd_lookup_values fvl101
142331: , fnd_lookup_values fvl104
142332: WHERE xet.event_id between x_first_event_id and x_last_event_id
142333: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 142330: , fnd_lookup_values fvl101

142326: , fnd_lookup_values fvl20
142327: , fnd_lookup_values fvl39
142328: , fnd_lookup_values fvl53
142329: , fnd_lookup_values fvl100
142330: , fnd_lookup_values fvl101
142331: , fnd_lookup_values fvl104
142332: WHERE xet.event_id between x_first_event_id and x_last_event_id
142333: and xet.event_date between p_pad_start_date and p_pad_end_date
142334: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 142331: , fnd_lookup_values fvl104

142327: , fnd_lookup_values fvl39
142328: , fnd_lookup_values fvl53
142329: , fnd_lookup_values fvl100
142330: , fnd_lookup_values fvl101
142331: , fnd_lookup_values fvl104
142332: WHERE xet.event_id between x_first_event_id and x_last_event_id
142333: and xet.event_date between p_pad_start_date and p_pad_end_date
142334: and xet.event_class_code = C_EVENT_CLASS_CODE
142335: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id