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

Line 96795: , fnd_lookup_values fvl16

96791: END source_meaning
96792: FROM xla_events_gt xet
96793: , AP_PAYMENT_EXTRACT_HEADER_V h2
96794: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
96795: , fnd_lookup_values fvl16
96796: , fnd_lookup_values fvl42
96797: , fnd_lookup_values fvl117
96798: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
96799: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 96796: , fnd_lookup_values fvl42

96792: FROM xla_events_gt xet
96793: , AP_PAYMENT_EXTRACT_HEADER_V h2
96794: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
96795: , fnd_lookup_values fvl16
96796: , fnd_lookup_values fvl42
96797: , fnd_lookup_values fvl117
96798: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
96799: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
96800: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 96797: , fnd_lookup_values fvl117

96793: , AP_PAYMENT_EXTRACT_HEADER_V h2
96794: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
96795: , fnd_lookup_values fvl16
96796: , fnd_lookup_values fvl42
96797: , fnd_lookup_values fvl117
96798: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
96799: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
96800: AND xet.event_class_code = C_EVENT_CLASS_CODE
96801: AND h2.event_id = xet.event_id

Line 96993: , fnd_lookup_values fvl51

96989: ELSE null
96990: END source_meaning
96991: FROM xla_events_gt xet
96992: , AP_PAYMENT_EXTRACT_DETAILS_V l1
96993: , fnd_lookup_values fvl51
96994: , fnd_lookup_values fvl64
96995: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
96996: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
96997: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 96994: , fnd_lookup_values fvl64

96990: END source_meaning
96991: FROM xla_events_gt xet
96992: , AP_PAYMENT_EXTRACT_DETAILS_V l1
96993: , fnd_lookup_values fvl51
96994: , fnd_lookup_values fvl64
96995: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
96996: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
96997: AND xet.event_class_code = C_EVENT_CLASS_CODE
96998: AND l1.event_id = xet.event_id

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

97133: l_balance_type_code VARCHAR2(1) :=NULL;
97134: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
97135:
97136: --
97137: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
97138: --
97139:
97140: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
97141: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 97296: , fnd_lookup_values fvl16

97292: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
97293: FROM xla_events_gt xet
97294: , AP_PAYMENT_EXTRACT_HEADER_V h2
97295: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
97296: , fnd_lookup_values fvl16
97297: , fnd_lookup_values fvl42
97298: , fnd_lookup_values fvl117
97299: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
97300: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 97297: , fnd_lookup_values fvl42

97293: FROM xla_events_gt xet
97294: , AP_PAYMENT_EXTRACT_HEADER_V h2
97295: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
97296: , fnd_lookup_values fvl16
97297: , fnd_lookup_values fvl42
97298: , fnd_lookup_values fvl117
97299: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
97300: and xet.event_class_code = C_EVENT_CLASS_CODE
97301: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 97298: , fnd_lookup_values fvl117

97294: , AP_PAYMENT_EXTRACT_HEADER_V h2
97295: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
97296: , fnd_lookup_values fvl16
97297: , fnd_lookup_values fvl42
97298: , fnd_lookup_values fvl117
97299: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
97300: and xet.event_class_code = C_EVENT_CLASS_CODE
97301: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
97302: AND h3.asp_org_id = h2.ac_org_id AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 97370: , fnd_lookup_values fvl51

97366: , l1.PMT_MAT_BASE_AMT_DIFF source_135
97367: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_140
97368: FROM xla_events_gt xet
97369: , AP_PAYMENT_EXTRACT_DETAILS_V l1
97370: , fnd_lookup_values fvl51
97371: , fnd_lookup_values fvl64
97372: WHERE xet.event_id between x_first_event_id and x_last_event_id
97373: and xet.event_date between p_pad_start_date and p_pad_end_date
97374: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 97371: , fnd_lookup_values fvl64

97367: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_140
97368: FROM xla_events_gt xet
97369: , AP_PAYMENT_EXTRACT_DETAILS_V l1
97370: , fnd_lookup_values fvl51
97371: , fnd_lookup_values fvl64
97372: WHERE xet.event_id between x_first_event_id and x_last_event_id
97373: and xet.event_date between p_pad_start_date and p_pad_end_date
97374: and xet.event_class_code = C_EVENT_CLASS_CODE
97375: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 98903: , fnd_lookup_values fvl15

98899: END source_meaning
98900: FROM xla_events_gt xet
98901: , AP_PAYMENT_EXTRACT_HEADER_V h2
98902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
98903: , fnd_lookup_values fvl15
98904: , fnd_lookup_values fvl16
98905: , fnd_lookup_values fvl24
98906: , fnd_lookup_values fvl30
98907: , fnd_lookup_values fvl42

Line 98904: , fnd_lookup_values fvl16

98900: FROM xla_events_gt xet
98901: , AP_PAYMENT_EXTRACT_HEADER_V h2
98902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
98903: , fnd_lookup_values fvl15
98904: , fnd_lookup_values fvl16
98905: , fnd_lookup_values fvl24
98906: , fnd_lookup_values fvl30
98907: , fnd_lookup_values fvl42
98908: , fnd_lookup_values fvl71

Line 98905: , fnd_lookup_values fvl24

98901: , AP_PAYMENT_EXTRACT_HEADER_V h2
98902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
98903: , fnd_lookup_values fvl15
98904: , fnd_lookup_values fvl16
98905: , fnd_lookup_values fvl24
98906: , fnd_lookup_values fvl30
98907: , fnd_lookup_values fvl42
98908: , fnd_lookup_values fvl71
98909: , fnd_lookup_values fvl117

Line 98906: , fnd_lookup_values fvl30

98902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
98903: , fnd_lookup_values fvl15
98904: , fnd_lookup_values fvl16
98905: , fnd_lookup_values fvl24
98906: , fnd_lookup_values fvl30
98907: , fnd_lookup_values fvl42
98908: , fnd_lookup_values fvl71
98909: , fnd_lookup_values fvl117
98910: , fnd_lookup_values fvl159

Line 98907: , fnd_lookup_values fvl42

98903: , fnd_lookup_values fvl15
98904: , fnd_lookup_values fvl16
98905: , fnd_lookup_values fvl24
98906: , fnd_lookup_values fvl30
98907: , fnd_lookup_values fvl42
98908: , fnd_lookup_values fvl71
98909: , fnd_lookup_values fvl117
98910: , fnd_lookup_values fvl159
98911: ,(select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)

Line 98908: , fnd_lookup_values fvl71

98904: , fnd_lookup_values fvl16
98905: , fnd_lookup_values fvl24
98906: , fnd_lookup_values fvl30
98907: , fnd_lookup_values fvl42
98908: , fnd_lookup_values fvl71
98909: , fnd_lookup_values fvl117
98910: , fnd_lookup_values fvl159
98911: ,(select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
98912: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 98909: , fnd_lookup_values fvl117

98905: , fnd_lookup_values fvl24
98906: , fnd_lookup_values fvl30
98907: , fnd_lookup_values fvl42
98908: , fnd_lookup_values fvl71
98909: , fnd_lookup_values fvl117
98910: , fnd_lookup_values fvl159
98911: ,(select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
98912: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
98913: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 98910: , fnd_lookup_values fvl159

98906: , fnd_lookup_values fvl30
98907: , fnd_lookup_values fvl42
98908: , fnd_lookup_values fvl71
98909: , fnd_lookup_values fvl117
98910: , fnd_lookup_values fvl159
98911: ,(select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
98912: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
98913: AND xet.event_class_code = C_EVENT_CLASS_CODE
98914: AND h2.event_id = xet.event_id

Line 99213: , fnd_lookup_values fvl19

99209: , AP_PAYMENT_EXTRACT_DETAILS_V l1
99210: , AP_PO_HEADERS_EXTRACT_V l3
99211: , ZX_AP_DEF_TAX_EXTRACT_V l5
99212: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
99213: , fnd_lookup_values fvl19
99214: , fnd_lookup_values fvl32
99215: , fnd_lookup_values fvl51
99216: , fnd_lookup_values fvl64
99217: , fnd_lookup_values fvl111

Line 99214: , fnd_lookup_values fvl32

99210: , AP_PO_HEADERS_EXTRACT_V l3
99211: , ZX_AP_DEF_TAX_EXTRACT_V l5
99212: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
99213: , fnd_lookup_values fvl19
99214: , fnd_lookup_values fvl32
99215: , fnd_lookup_values fvl51
99216: , fnd_lookup_values fvl64
99217: , fnd_lookup_values fvl111
99218: , fnd_lookup_values fvl112

Line 99215: , fnd_lookup_values fvl51

99211: , ZX_AP_DEF_TAX_EXTRACT_V l5
99212: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
99213: , fnd_lookup_values fvl19
99214: , fnd_lookup_values fvl32
99215: , fnd_lookup_values fvl51
99216: , fnd_lookup_values fvl64
99217: , fnd_lookup_values fvl111
99218: , fnd_lookup_values fvl112
99219: , (select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)

Line 99216: , fnd_lookup_values fvl64

99212: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
99213: , fnd_lookup_values fvl19
99214: , fnd_lookup_values fvl32
99215: , fnd_lookup_values fvl51
99216: , fnd_lookup_values fvl64
99217: , fnd_lookup_values fvl111
99218: , fnd_lookup_values fvl112
99219: , (select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)
99220: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 99217: , fnd_lookup_values fvl111

99213: , fnd_lookup_values fvl19
99214: , fnd_lookup_values fvl32
99215: , fnd_lookup_values fvl51
99216: , fnd_lookup_values fvl64
99217: , fnd_lookup_values fvl111
99218: , fnd_lookup_values fvl112
99219: , (select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)
99220: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
99221: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 99218: , fnd_lookup_values fvl112

99214: , fnd_lookup_values fvl32
99215: , fnd_lookup_values fvl51
99216: , fnd_lookup_values fvl64
99217: , fnd_lookup_values fvl111
99218: , fnd_lookup_values fvl112
99219: , (select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)
99220: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
99221: AND xet.event_class_code = C_EVENT_CLASS_CODE
99222: AND l1.event_id = xet.event_id

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

99373: l_balance_type_code VARCHAR2(1) :=NULL;
99374: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
99375:
99376: --
99377: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
99378: --
99379:
99380: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
99381: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 99618: , fnd_lookup_values fvl15

99614: , fvl159.meaning source_159_meaning
99615: FROM xla_events_gt xet
99616: , AP_PAYMENT_EXTRACT_HEADER_V h2
99617: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
99618: , fnd_lookup_values fvl15
99619: , fnd_lookup_values fvl16
99620: , fnd_lookup_values fvl24
99621: , fnd_lookup_values fvl30
99622: , fnd_lookup_values fvl42

Line 99619: , fnd_lookup_values fvl16

99615: FROM xla_events_gt xet
99616: , AP_PAYMENT_EXTRACT_HEADER_V h2
99617: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
99618: , fnd_lookup_values fvl15
99619: , fnd_lookup_values fvl16
99620: , fnd_lookup_values fvl24
99621: , fnd_lookup_values fvl30
99622: , fnd_lookup_values fvl42
99623: , fnd_lookup_values fvl71

Line 99620: , fnd_lookup_values fvl24

99616: , AP_PAYMENT_EXTRACT_HEADER_V h2
99617: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
99618: , fnd_lookup_values fvl15
99619: , fnd_lookup_values fvl16
99620: , fnd_lookup_values fvl24
99621: , fnd_lookup_values fvl30
99622: , fnd_lookup_values fvl42
99623: , fnd_lookup_values fvl71
99624: , fnd_lookup_values fvl117

Line 99621: , fnd_lookup_values fvl30

99617: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
99618: , fnd_lookup_values fvl15
99619: , fnd_lookup_values fvl16
99620: , fnd_lookup_values fvl24
99621: , fnd_lookup_values fvl30
99622: , fnd_lookup_values fvl42
99623: , fnd_lookup_values fvl71
99624: , fnd_lookup_values fvl117
99625: , fnd_lookup_values fvl159

Line 99622: , fnd_lookup_values fvl42

99618: , fnd_lookup_values fvl15
99619: , fnd_lookup_values fvl16
99620: , fnd_lookup_values fvl24
99621: , fnd_lookup_values fvl30
99622: , fnd_lookup_values fvl42
99623: , fnd_lookup_values fvl71
99624: , fnd_lookup_values fvl117
99625: , fnd_lookup_values fvl159
99626: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 99623: , fnd_lookup_values fvl71

99619: , fnd_lookup_values fvl16
99620: , fnd_lookup_values fvl24
99621: , fnd_lookup_values fvl30
99622: , fnd_lookup_values fvl42
99623: , fnd_lookup_values fvl71
99624: , fnd_lookup_values fvl117
99625: , fnd_lookup_values fvl159
99626: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
99627: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 99624: , fnd_lookup_values fvl117

99620: , fnd_lookup_values fvl24
99621: , fnd_lookup_values fvl30
99622: , fnd_lookup_values fvl42
99623: , fnd_lookup_values fvl71
99624: , fnd_lookup_values fvl117
99625: , fnd_lookup_values fvl159
99626: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
99627: and xet.event_class_code = C_EVENT_CLASS_CODE
99628: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 99625: , fnd_lookup_values fvl159

99621: , fnd_lookup_values fvl30
99622: , fnd_lookup_values fvl42
99623: , fnd_lookup_values fvl71
99624: , fnd_lookup_values fvl117
99625: , fnd_lookup_values fvl159
99626: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
99627: and xet.event_class_code = C_EVENT_CLASS_CODE
99628: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
99629: AND h4.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'

Line 99740: , fnd_lookup_values fvl19

99736: , AP_PAYMENT_EXTRACT_DETAILS_V l1
99737: , AP_PO_HEADERS_EXTRACT_V l3
99738: , ZX_AP_DEF_TAX_EXTRACT_V l5
99739: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
99740: , fnd_lookup_values fvl19
99741: , fnd_lookup_values fvl32
99742: , fnd_lookup_values fvl51
99743: , fnd_lookup_values fvl64
99744: , fnd_lookup_values fvl111

Line 99741: , fnd_lookup_values fvl32

99737: , AP_PO_HEADERS_EXTRACT_V l3
99738: , ZX_AP_DEF_TAX_EXTRACT_V l5
99739: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
99740: , fnd_lookup_values fvl19
99741: , fnd_lookup_values fvl32
99742: , fnd_lookup_values fvl51
99743: , fnd_lookup_values fvl64
99744: , fnd_lookup_values fvl111
99745: , fnd_lookup_values fvl112

Line 99742: , fnd_lookup_values fvl51

99738: , ZX_AP_DEF_TAX_EXTRACT_V l5
99739: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
99740: , fnd_lookup_values fvl19
99741: , fnd_lookup_values fvl32
99742: , fnd_lookup_values fvl51
99743: , fnd_lookup_values fvl64
99744: , fnd_lookup_values fvl111
99745: , fnd_lookup_values fvl112
99746: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 99743: , fnd_lookup_values fvl64

99739: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
99740: , fnd_lookup_values fvl19
99741: , fnd_lookup_values fvl32
99742: , fnd_lookup_values fvl51
99743: , fnd_lookup_values fvl64
99744: , fnd_lookup_values fvl111
99745: , fnd_lookup_values fvl112
99746: WHERE xet.event_id between x_first_event_id and x_last_event_id
99747: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 99744: , fnd_lookup_values fvl111

99740: , fnd_lookup_values fvl19
99741: , fnd_lookup_values fvl32
99742: , fnd_lookup_values fvl51
99743: , fnd_lookup_values fvl64
99744: , fnd_lookup_values fvl111
99745: , fnd_lookup_values fvl112
99746: WHERE xet.event_id between x_first_event_id and x_last_event_id
99747: and xet.event_date between p_pad_start_date and p_pad_end_date
99748: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 99745: , fnd_lookup_values fvl112

99741: , fnd_lookup_values fvl32
99742: , fnd_lookup_values fvl51
99743: , fnd_lookup_values fvl64
99744: , fnd_lookup_values fvl111
99745: , fnd_lookup_values fvl112
99746: WHERE xet.event_id between x_first_event_id and x_last_event_id
99747: and xet.event_date between p_pad_start_date and p_pad_end_date
99748: and xet.event_class_code = C_EVENT_CLASS_CODE
99749: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 102252: , fnd_lookup_values fvl16

102248: END source_meaning
102249: FROM xla_events_gt xet
102250: , AP_INVOICE_EXTRACT_HEADER_V h1
102251: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
102252: , fnd_lookup_values fvl16
102253: , fnd_lookup_values fvl42
102254: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
102255: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
102256: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 102253: , fnd_lookup_values fvl42

102249: FROM xla_events_gt xet
102250: , AP_INVOICE_EXTRACT_HEADER_V h1
102251: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
102252: , fnd_lookup_values fvl16
102253: , fnd_lookup_values fvl42
102254: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
102255: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
102256: AND xet.event_class_code = C_EVENT_CLASS_CODE
102257: AND h1.event_id = xet.event_id

Line 102671: , fnd_lookup_values fvl19

102667: , AP_PO_HEADERS_EXTRACT_V l2
102668: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
102669: , ZX_AP_DEF_TAX_EXTRACT_V l5
102670: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
102671: , fnd_lookup_values fvl19
102672: , fnd_lookup_values fvl64
102673: , fnd_lookup_values fvl79
102674: , fnd_lookup_values fvl111
102675: , fnd_lookup_values fvl148

Line 102672: , fnd_lookup_values fvl64

102668: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
102669: , ZX_AP_DEF_TAX_EXTRACT_V l5
102670: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
102671: , fnd_lookup_values fvl19
102672: , fnd_lookup_values fvl64
102673: , fnd_lookup_values fvl79
102674: , fnd_lookup_values fvl111
102675: , fnd_lookup_values fvl148
102676: , (select rownum r from all_objects where rownum <= 61 and owner = p_apps_owner)

Line 102673: , fnd_lookup_values fvl79

102669: , ZX_AP_DEF_TAX_EXTRACT_V l5
102670: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
102671: , fnd_lookup_values fvl19
102672: , fnd_lookup_values fvl64
102673: , fnd_lookup_values fvl79
102674: , fnd_lookup_values fvl111
102675: , fnd_lookup_values fvl148
102676: , (select rownum r from all_objects where rownum <= 61 and owner = p_apps_owner)
102677: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 102674: , fnd_lookup_values fvl111

102670: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
102671: , fnd_lookup_values fvl19
102672: , fnd_lookup_values fvl64
102673: , fnd_lookup_values fvl79
102674: , fnd_lookup_values fvl111
102675: , fnd_lookup_values fvl148
102676: , (select rownum r from all_objects where rownum <= 61 and owner = p_apps_owner)
102677: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
102678: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 102675: , fnd_lookup_values fvl148

102671: , fnd_lookup_values fvl19
102672: , fnd_lookup_values fvl64
102673: , fnd_lookup_values fvl79
102674: , fnd_lookup_values fvl111
102675: , fnd_lookup_values fvl148
102676: , (select rownum r from all_objects where rownum <= 61 and owner = p_apps_owner)
102677: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
102678: AND xet.event_class_code = C_EVENT_CLASS_CODE
102679: AND l3.event_id = xet.event_id

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

102826: l_balance_type_code VARCHAR2(1) :=NULL;
102827: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
102828:
102829: --
102830: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
102831: --
102832:
102833: TYPE t_array_source_2 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
102834: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 103066: , fnd_lookup_values fvl16

103062: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_160
103063: FROM xla_events_gt xet
103064: , AP_INVOICE_EXTRACT_HEADER_V h1
103065: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
103066: , fnd_lookup_values fvl16
103067: , fnd_lookup_values fvl42
103068: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
103069: and xet.event_class_code = C_EVENT_CLASS_CODE
103070: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 103067: , fnd_lookup_values fvl42

103063: FROM xla_events_gt xet
103064: , AP_INVOICE_EXTRACT_HEADER_V h1
103065: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
103066: , fnd_lookup_values fvl16
103067: , fnd_lookup_values fvl42
103068: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
103069: and xet.event_class_code = C_EVENT_CLASS_CODE
103070: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
103071: AND h4.asp_org_id = h1.ai_org_id AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

Line 103185: , fnd_lookup_values fvl19

103181: , AP_PO_HEADERS_EXTRACT_V l2
103182: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
103183: , ZX_AP_DEF_TAX_EXTRACT_V l5
103184: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
103185: , fnd_lookup_values fvl19
103186: , fnd_lookup_values fvl64
103187: , fnd_lookup_values fvl79
103188: , fnd_lookup_values fvl111
103189: , fnd_lookup_values fvl148

Line 103186: , fnd_lookup_values fvl64

103182: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
103183: , ZX_AP_DEF_TAX_EXTRACT_V l5
103184: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
103185: , fnd_lookup_values fvl19
103186: , fnd_lookup_values fvl64
103187: , fnd_lookup_values fvl79
103188: , fnd_lookup_values fvl111
103189: , fnd_lookup_values fvl148
103190: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 103187: , fnd_lookup_values fvl79

103183: , ZX_AP_DEF_TAX_EXTRACT_V l5
103184: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
103185: , fnd_lookup_values fvl19
103186: , fnd_lookup_values fvl64
103187: , fnd_lookup_values fvl79
103188: , fnd_lookup_values fvl111
103189: , fnd_lookup_values fvl148
103190: WHERE xet.event_id between x_first_event_id and x_last_event_id
103191: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 103188: , fnd_lookup_values fvl111

103184: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
103185: , fnd_lookup_values fvl19
103186: , fnd_lookup_values fvl64
103187: , fnd_lookup_values fvl79
103188: , fnd_lookup_values fvl111
103189: , fnd_lookup_values fvl148
103190: WHERE xet.event_id between x_first_event_id and x_last_event_id
103191: and xet.event_date between p_pad_start_date and p_pad_end_date
103192: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 103189: , fnd_lookup_values fvl148

103185: , fnd_lookup_values fvl19
103186: , fnd_lookup_values fvl64
103187: , fnd_lookup_values fvl79
103188: , fnd_lookup_values fvl111
103189: , fnd_lookup_values fvl148
103190: WHERE xet.event_id between x_first_event_id and x_last_event_id
103191: and xet.event_date between p_pad_start_date and p_pad_end_date
103192: and xet.event_class_code = C_EVENT_CLASS_CODE
103193: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 106471: , fnd_lookup_values fvl15

106467: END source_meaning
106468: FROM xla_events_gt xet
106469: , AP_PAYMENT_EXTRACT_HEADER_V h2
106470: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
106471: , fnd_lookup_values fvl15
106472: , fnd_lookup_values fvl16
106473: , fnd_lookup_values fvl42
106474: , fnd_lookup_values fvl71
106475: , fnd_lookup_values fvl117

Line 106472: , fnd_lookup_values fvl16

106468: FROM xla_events_gt xet
106469: , AP_PAYMENT_EXTRACT_HEADER_V h2
106470: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
106471: , fnd_lookup_values fvl15
106472: , fnd_lookup_values fvl16
106473: , fnd_lookup_values fvl42
106474: , fnd_lookup_values fvl71
106475: , fnd_lookup_values fvl117
106476: ,(select rownum r from all_objects where rownum <= 40 and owner = p_apps_owner)

Line 106473: , fnd_lookup_values fvl42

106469: , AP_PAYMENT_EXTRACT_HEADER_V h2
106470: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
106471: , fnd_lookup_values fvl15
106472: , fnd_lookup_values fvl16
106473: , fnd_lookup_values fvl42
106474: , fnd_lookup_values fvl71
106475: , fnd_lookup_values fvl117
106476: ,(select rownum r from all_objects where rownum <= 40 and owner = p_apps_owner)
106477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 106474: , fnd_lookup_values fvl71

106470: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
106471: , fnd_lookup_values fvl15
106472: , fnd_lookup_values fvl16
106473: , fnd_lookup_values fvl42
106474: , fnd_lookup_values fvl71
106475: , fnd_lookup_values fvl117
106476: ,(select rownum r from all_objects where rownum <= 40 and owner = p_apps_owner)
106477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
106478: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 106475: , fnd_lookup_values fvl117

106471: , fnd_lookup_values fvl15
106472: , fnd_lookup_values fvl16
106473: , fnd_lookup_values fvl42
106474: , fnd_lookup_values fvl71
106475: , fnd_lookup_values fvl117
106476: ,(select rownum r from all_objects where rownum <= 40 and owner = p_apps_owner)
106477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
106478: AND xet.event_class_code = C_EVENT_CLASS_CODE
106479: AND h2.event_id = xet.event_id

Line 106786: , fnd_lookup_values fvl19

106782: FROM xla_events_gt xet
106783: , AP_PAYMENT_EXTRACT_DETAILS_V l1
106784: , AP_PO_HEADERS_EXTRACT_V l3
106785: , ZX_AP_DEF_TAX_EXTRACT_V l5
106786: , fnd_lookup_values fvl19
106787: , fnd_lookup_values fvl32
106788: , fnd_lookup_values fvl51
106789: , fnd_lookup_values fvl64
106790: , fnd_lookup_values fvl111

Line 106787: , fnd_lookup_values fvl32

106783: , AP_PAYMENT_EXTRACT_DETAILS_V l1
106784: , AP_PO_HEADERS_EXTRACT_V l3
106785: , ZX_AP_DEF_TAX_EXTRACT_V l5
106786: , fnd_lookup_values fvl19
106787: , fnd_lookup_values fvl32
106788: , fnd_lookup_values fvl51
106789: , fnd_lookup_values fvl64
106790: , fnd_lookup_values fvl111
106791: , fnd_lookup_values fvl112

Line 106788: , fnd_lookup_values fvl51

106784: , AP_PO_HEADERS_EXTRACT_V l3
106785: , ZX_AP_DEF_TAX_EXTRACT_V l5
106786: , fnd_lookup_values fvl19
106787: , fnd_lookup_values fvl32
106788: , fnd_lookup_values fvl51
106789: , fnd_lookup_values fvl64
106790: , fnd_lookup_values fvl111
106791: , fnd_lookup_values fvl112
106792: , fnd_lookup_values fvl155

Line 106789: , fnd_lookup_values fvl64

106785: , ZX_AP_DEF_TAX_EXTRACT_V l5
106786: , fnd_lookup_values fvl19
106787: , fnd_lookup_values fvl32
106788: , fnd_lookup_values fvl51
106789: , fnd_lookup_values fvl64
106790: , fnd_lookup_values fvl111
106791: , fnd_lookup_values fvl112
106792: , fnd_lookup_values fvl155
106793: , (select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)

Line 106790: , fnd_lookup_values fvl111

106786: , fnd_lookup_values fvl19
106787: , fnd_lookup_values fvl32
106788: , fnd_lookup_values fvl51
106789: , fnd_lookup_values fvl64
106790: , fnd_lookup_values fvl111
106791: , fnd_lookup_values fvl112
106792: , fnd_lookup_values fvl155
106793: , (select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)
106794: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 106791: , fnd_lookup_values fvl112

106787: , fnd_lookup_values fvl32
106788: , fnd_lookup_values fvl51
106789: , fnd_lookup_values fvl64
106790: , fnd_lookup_values fvl111
106791: , fnd_lookup_values fvl112
106792: , fnd_lookup_values fvl155
106793: , (select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)
106794: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
106795: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 106792: , fnd_lookup_values fvl155

106788: , fnd_lookup_values fvl51
106789: , fnd_lookup_values fvl64
106790: , fnd_lookup_values fvl111
106791: , fnd_lookup_values fvl112
106792: , fnd_lookup_values fvl155
106793: , (select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)
106794: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
106795: AND xet.event_class_code = C_EVENT_CLASS_CODE
106796: AND l1.event_id = xet.event_id

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

106951: l_balance_type_code VARCHAR2(1) :=NULL;
106952: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
106953:
106954: --
106955: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
106956: --
106957:
106958: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
106959: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 107205: , fnd_lookup_values fvl15

107201: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
107202: FROM xla_events_gt xet
107203: , AP_PAYMENT_EXTRACT_HEADER_V h2
107204: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
107205: , fnd_lookup_values fvl15
107206: , fnd_lookup_values fvl16
107207: , fnd_lookup_values fvl42
107208: , fnd_lookup_values fvl71
107209: , fnd_lookup_values fvl117

Line 107206: , fnd_lookup_values fvl16

107202: FROM xla_events_gt xet
107203: , AP_PAYMENT_EXTRACT_HEADER_V h2
107204: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
107205: , fnd_lookup_values fvl15
107206: , fnd_lookup_values fvl16
107207: , fnd_lookup_values fvl42
107208: , fnd_lookup_values fvl71
107209: , fnd_lookup_values fvl117
107210: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 107207: , fnd_lookup_values fvl42

107203: , AP_PAYMENT_EXTRACT_HEADER_V h2
107204: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
107205: , fnd_lookup_values fvl15
107206: , fnd_lookup_values fvl16
107207: , fnd_lookup_values fvl42
107208: , fnd_lookup_values fvl71
107209: , fnd_lookup_values fvl117
107210: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
107211: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 107208: , fnd_lookup_values fvl71

107204: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
107205: , fnd_lookup_values fvl15
107206: , fnd_lookup_values fvl16
107207: , fnd_lookup_values fvl42
107208: , fnd_lookup_values fvl71
107209: , fnd_lookup_values fvl117
107210: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
107211: and xet.event_class_code = C_EVENT_CLASS_CODE
107212: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 107209: , fnd_lookup_values fvl117

107205: , fnd_lookup_values fvl15
107206: , fnd_lookup_values fvl16
107207: , fnd_lookup_values fvl42
107208: , fnd_lookup_values fvl71
107209: , fnd_lookup_values fvl117
107210: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
107211: and xet.event_class_code = C_EVENT_CLASS_CODE
107212: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
107213: AND h4.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'

Line 107316: , fnd_lookup_values fvl19

107312: FROM xla_events_gt xet
107313: , AP_PAYMENT_EXTRACT_DETAILS_V l1
107314: , AP_PO_HEADERS_EXTRACT_V l3
107315: , ZX_AP_DEF_TAX_EXTRACT_V l5
107316: , fnd_lookup_values fvl19
107317: , fnd_lookup_values fvl32
107318: , fnd_lookup_values fvl51
107319: , fnd_lookup_values fvl64
107320: , fnd_lookup_values fvl111

Line 107317: , fnd_lookup_values fvl32

107313: , AP_PAYMENT_EXTRACT_DETAILS_V l1
107314: , AP_PO_HEADERS_EXTRACT_V l3
107315: , ZX_AP_DEF_TAX_EXTRACT_V l5
107316: , fnd_lookup_values fvl19
107317: , fnd_lookup_values fvl32
107318: , fnd_lookup_values fvl51
107319: , fnd_lookup_values fvl64
107320: , fnd_lookup_values fvl111
107321: , fnd_lookup_values fvl112

Line 107318: , fnd_lookup_values fvl51

107314: , AP_PO_HEADERS_EXTRACT_V l3
107315: , ZX_AP_DEF_TAX_EXTRACT_V l5
107316: , fnd_lookup_values fvl19
107317: , fnd_lookup_values fvl32
107318: , fnd_lookup_values fvl51
107319: , fnd_lookup_values fvl64
107320: , fnd_lookup_values fvl111
107321: , fnd_lookup_values fvl112
107322: , fnd_lookup_values fvl155

Line 107319: , fnd_lookup_values fvl64

107315: , ZX_AP_DEF_TAX_EXTRACT_V l5
107316: , fnd_lookup_values fvl19
107317: , fnd_lookup_values fvl32
107318: , fnd_lookup_values fvl51
107319: , fnd_lookup_values fvl64
107320: , fnd_lookup_values fvl111
107321: , fnd_lookup_values fvl112
107322: , fnd_lookup_values fvl155
107323: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 107320: , fnd_lookup_values fvl111

107316: , fnd_lookup_values fvl19
107317: , fnd_lookup_values fvl32
107318: , fnd_lookup_values fvl51
107319: , fnd_lookup_values fvl64
107320: , fnd_lookup_values fvl111
107321: , fnd_lookup_values fvl112
107322: , fnd_lookup_values fvl155
107323: WHERE xet.event_id between x_first_event_id and x_last_event_id
107324: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 107321: , fnd_lookup_values fvl112

107317: , fnd_lookup_values fvl32
107318: , fnd_lookup_values fvl51
107319: , fnd_lookup_values fvl64
107320: , fnd_lookup_values fvl111
107321: , fnd_lookup_values fvl112
107322: , fnd_lookup_values fvl155
107323: WHERE xet.event_id between x_first_event_id and x_last_event_id
107324: and xet.event_date between p_pad_start_date and p_pad_end_date
107325: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 107322: , fnd_lookup_values fvl155

107318: , fnd_lookup_values fvl51
107319: , fnd_lookup_values fvl64
107320: , fnd_lookup_values fvl111
107321: , fnd_lookup_values fvl112
107322: , fnd_lookup_values fvl155
107323: WHERE xet.event_id between x_first_event_id and x_last_event_id
107324: and xet.event_date between p_pad_start_date and p_pad_end_date
107325: and xet.event_class_code = C_EVENT_CLASS_CODE
107326: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 109975: , fnd_lookup_values fvl15

109971: END source_meaning
109972: FROM xla_events_gt xet
109973: , AP_PAYMENT_EXTRACT_HEADER_V h2
109974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
109975: , fnd_lookup_values fvl15
109976: , fnd_lookup_values fvl16
109977: , fnd_lookup_values fvl42
109978: , fnd_lookup_values fvl71
109979: , fnd_lookup_values fvl117

Line 109976: , fnd_lookup_values fvl16

109972: FROM xla_events_gt xet
109973: , AP_PAYMENT_EXTRACT_HEADER_V h2
109974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
109975: , fnd_lookup_values fvl15
109976: , fnd_lookup_values fvl16
109977: , fnd_lookup_values fvl42
109978: , fnd_lookup_values fvl71
109979: , fnd_lookup_values fvl117
109980: , fnd_lookup_values fvl159

Line 109977: , fnd_lookup_values fvl42

109973: , AP_PAYMENT_EXTRACT_HEADER_V h2
109974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
109975: , fnd_lookup_values fvl15
109976: , fnd_lookup_values fvl16
109977: , fnd_lookup_values fvl42
109978: , fnd_lookup_values fvl71
109979: , fnd_lookup_values fvl117
109980: , fnd_lookup_values fvl159
109981: ,(select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)

Line 109978: , fnd_lookup_values fvl71

109974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
109975: , fnd_lookup_values fvl15
109976: , fnd_lookup_values fvl16
109977: , fnd_lookup_values fvl42
109978: , fnd_lookup_values fvl71
109979: , fnd_lookup_values fvl117
109980: , fnd_lookup_values fvl159
109981: ,(select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
109982: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 109979: , fnd_lookup_values fvl117

109975: , fnd_lookup_values fvl15
109976: , fnd_lookup_values fvl16
109977: , fnd_lookup_values fvl42
109978: , fnd_lookup_values fvl71
109979: , fnd_lookup_values fvl117
109980: , fnd_lookup_values fvl159
109981: ,(select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
109982: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
109983: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 109980: , fnd_lookup_values fvl159

109976: , fnd_lookup_values fvl16
109977: , fnd_lookup_values fvl42
109978: , fnd_lookup_values fvl71
109979: , fnd_lookup_values fvl117
109980: , fnd_lookup_values fvl159
109981: ,(select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
109982: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
109983: AND xet.event_class_code = C_EVENT_CLASS_CODE
109984: AND h2.event_id = xet.event_id

Line 110239: , fnd_lookup_values fvl19

110235: , AP_PAYMENT_EXTRACT_DETAILS_V l1
110236: , AP_PO_HEADERS_EXTRACT_V l3
110237: , ZX_AP_DEF_TAX_EXTRACT_V l5
110238: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
110239: , fnd_lookup_values fvl19
110240: , fnd_lookup_values fvl32
110241: , fnd_lookup_values fvl51
110242: , fnd_lookup_values fvl64
110243: , fnd_lookup_values fvl111

Line 110240: , fnd_lookup_values fvl32

110236: , AP_PO_HEADERS_EXTRACT_V l3
110237: , ZX_AP_DEF_TAX_EXTRACT_V l5
110238: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
110239: , fnd_lookup_values fvl19
110240: , fnd_lookup_values fvl32
110241: , fnd_lookup_values fvl51
110242: , fnd_lookup_values fvl64
110243: , fnd_lookup_values fvl111
110244: , (select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)

Line 110241: , fnd_lookup_values fvl51

110237: , ZX_AP_DEF_TAX_EXTRACT_V l5
110238: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
110239: , fnd_lookup_values fvl19
110240: , fnd_lookup_values fvl32
110241: , fnd_lookup_values fvl51
110242: , fnd_lookup_values fvl64
110243: , fnd_lookup_values fvl111
110244: , (select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
110245: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 110242: , fnd_lookup_values fvl64

110238: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
110239: , fnd_lookup_values fvl19
110240: , fnd_lookup_values fvl32
110241: , fnd_lookup_values fvl51
110242: , fnd_lookup_values fvl64
110243: , fnd_lookup_values fvl111
110244: , (select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
110245: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
110246: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 110243: , fnd_lookup_values fvl111

110239: , fnd_lookup_values fvl19
110240: , fnd_lookup_values fvl32
110241: , fnd_lookup_values fvl51
110242: , fnd_lookup_values fvl64
110243: , fnd_lookup_values fvl111
110244: , (select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
110245: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
110246: AND xet.event_class_code = C_EVENT_CLASS_CODE
110247: AND l1.event_id = xet.event_id

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

110394: l_balance_type_code VARCHAR2(1) :=NULL;
110395: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
110396:
110397: --
110398: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
110399: --
110400:
110401: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
110402: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 110590: , fnd_lookup_values fvl15

110586: , fvl159.meaning source_159_meaning
110587: FROM xla_events_gt xet
110588: , AP_PAYMENT_EXTRACT_HEADER_V h2
110589: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
110590: , fnd_lookup_values fvl15
110591: , fnd_lookup_values fvl16
110592: , fnd_lookup_values fvl42
110593: , fnd_lookup_values fvl71
110594: , fnd_lookup_values fvl117

Line 110591: , fnd_lookup_values fvl16

110587: FROM xla_events_gt xet
110588: , AP_PAYMENT_EXTRACT_HEADER_V h2
110589: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
110590: , fnd_lookup_values fvl15
110591: , fnd_lookup_values fvl16
110592: , fnd_lookup_values fvl42
110593: , fnd_lookup_values fvl71
110594: , fnd_lookup_values fvl117
110595: , fnd_lookup_values fvl159

Line 110592: , fnd_lookup_values fvl42

110588: , AP_PAYMENT_EXTRACT_HEADER_V h2
110589: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
110590: , fnd_lookup_values fvl15
110591: , fnd_lookup_values fvl16
110592: , fnd_lookup_values fvl42
110593: , fnd_lookup_values fvl71
110594: , fnd_lookup_values fvl117
110595: , fnd_lookup_values fvl159
110596: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 110593: , fnd_lookup_values fvl71

110589: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
110590: , fnd_lookup_values fvl15
110591: , fnd_lookup_values fvl16
110592: , fnd_lookup_values fvl42
110593: , fnd_lookup_values fvl71
110594: , fnd_lookup_values fvl117
110595: , fnd_lookup_values fvl159
110596: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
110597: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 110594: , fnd_lookup_values fvl117

110590: , fnd_lookup_values fvl15
110591: , fnd_lookup_values fvl16
110592: , fnd_lookup_values fvl42
110593: , fnd_lookup_values fvl71
110594: , fnd_lookup_values fvl117
110595: , fnd_lookup_values fvl159
110596: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
110597: and xet.event_class_code = C_EVENT_CLASS_CODE
110598: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 110595: , fnd_lookup_values fvl159

110591: , fnd_lookup_values fvl16
110592: , fnd_lookup_values fvl42
110593: , fnd_lookup_values fvl71
110594: , fnd_lookup_values fvl117
110595: , fnd_lookup_values fvl159
110596: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
110597: and xet.event_class_code = C_EVENT_CLASS_CODE
110598: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
110599: AND h4.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'

Line 110694: , fnd_lookup_values fvl19

110690: , AP_PAYMENT_EXTRACT_DETAILS_V l1
110691: , AP_PO_HEADERS_EXTRACT_V l3
110692: , ZX_AP_DEF_TAX_EXTRACT_V l5
110693: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
110694: , fnd_lookup_values fvl19
110695: , fnd_lookup_values fvl32
110696: , fnd_lookup_values fvl51
110697: , fnd_lookup_values fvl64
110698: , fnd_lookup_values fvl111

Line 110695: , fnd_lookup_values fvl32

110691: , AP_PO_HEADERS_EXTRACT_V l3
110692: , ZX_AP_DEF_TAX_EXTRACT_V l5
110693: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
110694: , fnd_lookup_values fvl19
110695: , fnd_lookup_values fvl32
110696: , fnd_lookup_values fvl51
110697: , fnd_lookup_values fvl64
110698: , fnd_lookup_values fvl111
110699: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 110696: , fnd_lookup_values fvl51

110692: , ZX_AP_DEF_TAX_EXTRACT_V l5
110693: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
110694: , fnd_lookup_values fvl19
110695: , fnd_lookup_values fvl32
110696: , fnd_lookup_values fvl51
110697: , fnd_lookup_values fvl64
110698: , fnd_lookup_values fvl111
110699: WHERE xet.event_id between x_first_event_id and x_last_event_id
110700: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 110697: , fnd_lookup_values fvl64

110693: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
110694: , fnd_lookup_values fvl19
110695: , fnd_lookup_values fvl32
110696: , fnd_lookup_values fvl51
110697: , fnd_lookup_values fvl64
110698: , fnd_lookup_values fvl111
110699: WHERE xet.event_id between x_first_event_id and x_last_event_id
110700: and xet.event_date between p_pad_start_date and p_pad_end_date
110701: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 110698: , fnd_lookup_values fvl111

110694: , fnd_lookup_values fvl19
110695: , fnd_lookup_values fvl32
110696: , fnd_lookup_values fvl51
110697: , fnd_lookup_values fvl64
110698: , fnd_lookup_values fvl111
110699: WHERE xet.event_id between x_first_event_id and x_last_event_id
110700: and xet.event_date between p_pad_start_date and p_pad_end_date
110701: and xet.event_class_code = C_EVENT_CLASS_CODE
110702: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id