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

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

66893: l_balance_type_code VARCHAR2(1) :=NULL;
66894: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
66895:
66896: --
66897: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
66898: --
66899:
66900: TYPE t_array_source_1 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
66901: TYPE t_array_source_2 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

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

68357: l_balance_type_code VARCHAR2(1) :=NULL;
68358: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
68359:
68360: --
68361: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68362: --
68363:
68364: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
68365: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

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

69747: l_balance_type_code VARCHAR2(1) :=NULL;
69748: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
69749:
69750: --
69751: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69752: --
69753:
69754: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69755: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 70798: , fnd_lookup_values fvl124

70794: , AR_BILL_TO_SITE_USES_S_V h2
70795: , AR_REMIT_BANK_ACCT_H_V h3
70796: , AR_TRANSACTIONS_S_V h4
70797: , JL_BR_AR_COLL_OCC_DOCS_H_V h6
70798: , fnd_lookup_values fvl124
70799: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
70800: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70801: AND xet.event_class_code = C_EVENT_CLASS_CODE
70802: AND h3.event_id = xet.event_id

Line 71017: , fnd_lookup_values fvl13

71013: ELSE null
71014: END source_meaning
71015: FROM xla_events_gt xet
71016: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
71017: , fnd_lookup_values fvl13
71018: , fnd_lookup_values fvl77
71019: , fnd_lookup_values fvl78
71020: , fnd_lookup_values fvl96
71021: , (select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)

Line 71018: , fnd_lookup_values fvl77

71014: END source_meaning
71015: FROM xla_events_gt xet
71016: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
71017: , fnd_lookup_values fvl13
71018: , fnd_lookup_values fvl77
71019: , fnd_lookup_values fvl78
71020: , fnd_lookup_values fvl96
71021: , (select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
71022: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 71019: , fnd_lookup_values fvl78

71015: FROM xla_events_gt xet
71016: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
71017: , fnd_lookup_values fvl13
71018: , fnd_lookup_values fvl77
71019: , fnd_lookup_values fvl78
71020: , fnd_lookup_values fvl96
71021: , (select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
71022: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71023: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 71020: , fnd_lookup_values fvl96

71016: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
71017: , fnd_lookup_values fvl13
71018: , fnd_lookup_values fvl77
71019: , fnd_lookup_values fvl78
71020: , fnd_lookup_values fvl96
71021: , (select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
71022: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71023: AND xet.event_class_code = C_EVENT_CLASS_CODE
71024: AND l5.event_id = xet.event_id

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

71167: l_balance_type_code VARCHAR2(1) :=NULL;
71168: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
71169:
71170: --
71171: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
71172: --
71173:
71174: TYPE t_array_source_10 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;
71175: TYPE t_array_source_11 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 71314: , fnd_lookup_values fvl124

71310: , AR_BILL_TO_SITE_USES_S_V h2
71311: , AR_REMIT_BANK_ACCT_H_V h3
71312: , AR_TRANSACTIONS_S_V h4
71313: , JL_BR_AR_COLL_OCC_DOCS_H_V h6
71314: , fnd_lookup_values fvl124
71315: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
71316: and xet.event_class_code = C_EVENT_CLASS_CODE
71317: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
71318: AND h1.event_id (+) = h3.event_id

Line 71389: , fnd_lookup_values fvl13

71385: , l5.JLBR_BANK_OCC_TYPE source_96
71386: , fvl96.meaning source_96_meaning
71387: FROM xla_events_gt xet
71388: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
71389: , fnd_lookup_values fvl13
71390: , fnd_lookup_values fvl77
71391: , fnd_lookup_values fvl78
71392: , fnd_lookup_values fvl96
71393: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 71390: , fnd_lookup_values fvl77

71386: , fvl96.meaning source_96_meaning
71387: FROM xla_events_gt xet
71388: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
71389: , fnd_lookup_values fvl13
71390: , fnd_lookup_values fvl77
71391: , fnd_lookup_values fvl78
71392: , fnd_lookup_values fvl96
71393: WHERE xet.event_id between x_first_event_id and x_last_event_id
71394: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 71391: , fnd_lookup_values fvl78

71387: FROM xla_events_gt xet
71388: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
71389: , fnd_lookup_values fvl13
71390: , fnd_lookup_values fvl77
71391: , fnd_lookup_values fvl78
71392: , fnd_lookup_values fvl96
71393: WHERE xet.event_id between x_first_event_id and x_last_event_id
71394: and xet.event_date between p_pad_start_date and p_pad_end_date
71395: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 71392: , fnd_lookup_values fvl96

71388: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
71389: , fnd_lookup_values fvl13
71390: , fnd_lookup_values fvl77
71391: , fnd_lookup_values fvl78
71392: , fnd_lookup_values fvl96
71393: WHERE xet.event_id between x_first_event_id and x_last_event_id
71394: and xet.event_date between p_pad_start_date and p_pad_end_date
71395: and xet.event_class_code = C_EVENT_CLASS_CODE
71396: and xet.event_status_code <> 'N' AND l5.event_id = xet.event_id

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

72847: l_balance_type_code VARCHAR2(1) :=NULL;
72848: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
72849:
72850: --
72851: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72852: --
72853:
72854: TYPE t_array_source_7 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
72855: TYPE t_array_source_8 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

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

74569: l_balance_type_code VARCHAR2(1) :=NULL;
74570: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
74571:
74572: --
74573: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
74574: --
74575:
74576: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
74577: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

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

76077: l_balance_type_code VARCHAR2(1) :=NULL;
76078: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
76079:
76080: --
76081: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76082: --
76083:
76084: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
76085: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 77128: , fnd_lookup_values fvl124

77124: , AR_BILL_TO_SITE_USES_S_V h2
77125: , AR_REMIT_BANK_ACCT_H_V h3
77126: , AR_TRANSACTIONS_S_V h4
77127: , JL_BR_AR_COLL_OCC_DOCS_H_V h6
77128: , fnd_lookup_values fvl124
77129: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
77130: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77131: AND xet.event_class_code = C_EVENT_CLASS_CODE
77132: AND h3.event_id = xet.event_id

Line 77352: , fnd_lookup_values fvl13

77348: ELSE null
77349: END source_meaning
77350: FROM xla_events_gt xet
77351: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
77352: , fnd_lookup_values fvl13
77353: , fnd_lookup_values fvl77
77354: , fnd_lookup_values fvl78
77355: , fnd_lookup_values fvl96
77356: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)

Line 77353: , fnd_lookup_values fvl77

77349: END source_meaning
77350: FROM xla_events_gt xet
77351: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
77352: , fnd_lookup_values fvl13
77353: , fnd_lookup_values fvl77
77354: , fnd_lookup_values fvl78
77355: , fnd_lookup_values fvl96
77356: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
77357: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 77354: , fnd_lookup_values fvl78

77350: FROM xla_events_gt xet
77351: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
77352: , fnd_lookup_values fvl13
77353: , fnd_lookup_values fvl77
77354: , fnd_lookup_values fvl78
77355: , fnd_lookup_values fvl96
77356: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
77357: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77358: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 77355: , fnd_lookup_values fvl96

77351: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
77352: , fnd_lookup_values fvl13
77353: , fnd_lookup_values fvl77
77354: , fnd_lookup_values fvl78
77355: , fnd_lookup_values fvl96
77356: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
77357: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77358: AND xet.event_class_code = C_EVENT_CLASS_CODE
77359: AND l5.event_id = xet.event_id

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

77502: l_balance_type_code VARCHAR2(1) :=NULL;
77503: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
77504:
77505: --
77506: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
77507: --
77508:
77509: TYPE t_array_source_10 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;
77510: TYPE t_array_source_11 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 77651: , fnd_lookup_values fvl124

77647: , AR_BILL_TO_SITE_USES_S_V h2
77648: , AR_REMIT_BANK_ACCT_H_V h3
77649: , AR_TRANSACTIONS_S_V h4
77650: , JL_BR_AR_COLL_OCC_DOCS_H_V h6
77651: , fnd_lookup_values fvl124
77652: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
77653: and xet.event_class_code = C_EVENT_CLASS_CODE
77654: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
77655: AND h1.event_id (+) = h3.event_id

Line 77727: , fnd_lookup_values fvl13

77723: , l5.JLBR_BANK_OCC_TYPE source_96
77724: , fvl96.meaning source_96_meaning
77725: FROM xla_events_gt xet
77726: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
77727: , fnd_lookup_values fvl13
77728: , fnd_lookup_values fvl77
77729: , fnd_lookup_values fvl78
77730: , fnd_lookup_values fvl96
77731: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 77728: , fnd_lookup_values fvl77

77724: , fvl96.meaning source_96_meaning
77725: FROM xla_events_gt xet
77726: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
77727: , fnd_lookup_values fvl13
77728: , fnd_lookup_values fvl77
77729: , fnd_lookup_values fvl78
77730: , fnd_lookup_values fvl96
77731: WHERE xet.event_id between x_first_event_id and x_last_event_id
77732: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 77729: , fnd_lookup_values fvl78

77725: FROM xla_events_gt xet
77726: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
77727: , fnd_lookup_values fvl13
77728: , fnd_lookup_values fvl77
77729: , fnd_lookup_values fvl78
77730: , fnd_lookup_values fvl96
77731: WHERE xet.event_id between x_first_event_id and x_last_event_id
77732: and xet.event_date between p_pad_start_date and p_pad_end_date
77733: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 77730: , fnd_lookup_values fvl96

77726: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
77727: , fnd_lookup_values fvl13
77728: , fnd_lookup_values fvl77
77729: , fnd_lookup_values fvl78
77730: , fnd_lookup_values fvl96
77731: WHERE xet.event_id between x_first_event_id and x_last_event_id
77732: and xet.event_date between p_pad_start_date and p_pad_end_date
77733: and xet.event_class_code = C_EVENT_CLASS_CODE
77734: and xet.event_status_code <> 'N' AND l5.event_id = xet.event_id

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

79176: l_balance_type_code VARCHAR2(1) :=NULL;
79177: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
79178:
79179: --
79180: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79181: --
79182:
79183: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79184: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

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

80464: l_balance_type_code VARCHAR2(1) :=NULL;
80465: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
80466:
80467: --
80468: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
80469: --
80470:
80471: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
80472: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

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

82085: l_balance_type_code VARCHAR2(1) :=NULL;
82086: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
82087:
82088: --
82089: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
82090: --
82091:
82092: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
82093: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;

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

83713: l_balance_type_code VARCHAR2(1) :=NULL;
83714: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
83715:
83716: --
83717: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
83718: --
83719:
83720: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
83721: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;