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

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

63391: l_balance_type_code VARCHAR2(1) :=NULL;
63392: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
63393:
63394: --
63395: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
63396: --
63397:
63398: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
63399: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

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

64830: l_balance_type_code VARCHAR2(1) :=NULL;
64831: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
64832:
64833: --
64834: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
64835: --
64836:
64837: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64838: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

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

66190: l_balance_type_code VARCHAR2(1) :=NULL;
66191: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
66192:
66193: --
66194: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
66195: --
66196:
66197: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
66198: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 67188: , fnd_lookup_values fvl116

67184: , AR_BILL_TO_CUSTOMERS_S_V h1
67185: , AR_BILL_TO_SITE_USES_S_V h2
67186: , AR_TRANSACTIONS_S_V h3
67187: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
67188: , fnd_lookup_values fvl116
67189: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
67190: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67191: AND xet.event_class_code = C_EVENT_CLASS_CODE
67192: AND h5.event_id = xet.event_id

Line 67406: , fnd_lookup_values fvl7

67402: ELSE null
67403: END source_meaning
67404: FROM xla_events_gt xet
67405: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
67406: , fnd_lookup_values fvl7
67407: , fnd_lookup_values fvl66
67408: , fnd_lookup_values fvl67
67409: , fnd_lookup_values fvl85
67410: , (select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)

Line 67407: , fnd_lookup_values fvl66

67403: END source_meaning
67404: FROM xla_events_gt xet
67405: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
67406: , fnd_lookup_values fvl7
67407: , fnd_lookup_values fvl66
67408: , fnd_lookup_values fvl67
67409: , fnd_lookup_values fvl85
67410: , (select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
67411: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 67408: , fnd_lookup_values fvl67

67404: FROM xla_events_gt xet
67405: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
67406: , fnd_lookup_values fvl7
67407: , fnd_lookup_values fvl66
67408: , fnd_lookup_values fvl67
67409: , fnd_lookup_values fvl85
67410: , (select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
67411: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67412: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 67409: , fnd_lookup_values fvl85

67405: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
67406: , fnd_lookup_values fvl7
67407: , fnd_lookup_values fvl66
67408: , fnd_lookup_values fvl67
67409: , fnd_lookup_values fvl85
67410: , (select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
67411: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67412: AND xet.event_class_code = C_EVENT_CLASS_CODE
67413: AND l4.event_id = xet.event_id

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

67556: l_balance_type_code VARCHAR2(1) :=NULL;
67557: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
67558:
67559: --
67560: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
67561: --
67562:
67563: TYPE t_array_source_4 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;
67564: TYPE t_array_source_5 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 67684: , fnd_lookup_values fvl116

67680: , AR_BILL_TO_CUSTOMERS_S_V h1
67681: , AR_BILL_TO_SITE_USES_S_V h2
67682: , AR_TRANSACTIONS_S_V h3
67683: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
67684: , fnd_lookup_values fvl116
67685: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
67686: and xet.event_class_code = C_EVENT_CLASS_CODE
67687: and xet.event_status_code <> 'N' AND h5.event_id = xet.event_id
67688: AND h1.event_id (+) = h5.event_id

Line 67758: , fnd_lookup_values fvl7

67754: , l4.JLBR_BANK_OCC_TYPE source_85
67755: , fvl85.meaning source_85_meaning
67756: FROM xla_events_gt xet
67757: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
67758: , fnd_lookup_values fvl7
67759: , fnd_lookup_values fvl66
67760: , fnd_lookup_values fvl67
67761: , fnd_lookup_values fvl85
67762: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 67759: , fnd_lookup_values fvl66

67755: , fvl85.meaning source_85_meaning
67756: FROM xla_events_gt xet
67757: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
67758: , fnd_lookup_values fvl7
67759: , fnd_lookup_values fvl66
67760: , fnd_lookup_values fvl67
67761: , fnd_lookup_values fvl85
67762: WHERE xet.event_id between x_first_event_id and x_last_event_id
67763: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 67760: , fnd_lookup_values fvl67

67756: FROM xla_events_gt xet
67757: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
67758: , fnd_lookup_values fvl7
67759: , fnd_lookup_values fvl66
67760: , fnd_lookup_values fvl67
67761: , fnd_lookup_values fvl85
67762: WHERE xet.event_id between x_first_event_id and x_last_event_id
67763: and xet.event_date between p_pad_start_date and p_pad_end_date
67764: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 67761: , fnd_lookup_values fvl85

67757: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
67758: , fnd_lookup_values fvl7
67759: , fnd_lookup_values fvl66
67760: , fnd_lookup_values fvl67
67761: , fnd_lookup_values fvl85
67762: WHERE xet.event_id between x_first_event_id and x_last_event_id
67763: and xet.event_date between p_pad_start_date and p_pad_end_date
67764: and xet.event_class_code = C_EVENT_CLASS_CODE
67765: and xet.event_status_code <> 'N' AND l4.event_id = xet.event_id

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

69180: l_balance_type_code VARCHAR2(1) :=NULL;
69181: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
69182:
69183: --
69184: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69185: --
69186:
69187: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
69188: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

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

70847: l_balance_type_code VARCHAR2(1) :=NULL;
70848: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
70849:
70850: --
70851: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
70852: --
70853:
70854: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
70855: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

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

72297: l_balance_type_code VARCHAR2(1) :=NULL;
72298: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
72299:
72300: --
72301: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72302: --
72303:
72304: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72305: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73295: , fnd_lookup_values fvl116

73291: , AR_BILL_TO_CUSTOMERS_S_V h1
73292: , AR_BILL_TO_SITE_USES_S_V h2
73293: , AR_TRANSACTIONS_S_V h3
73294: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
73295: , fnd_lookup_values fvl116
73296: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
73297: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73298: AND xet.event_class_code = C_EVENT_CLASS_CODE
73299: AND h5.event_id = xet.event_id

Line 73518: , fnd_lookup_values fvl7

73514: ELSE null
73515: END source_meaning
73516: FROM xla_events_gt xet
73517: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
73518: , fnd_lookup_values fvl7
73519: , fnd_lookup_values fvl66
73520: , fnd_lookup_values fvl67
73521: , fnd_lookup_values fvl85
73522: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)

Line 73519: , fnd_lookup_values fvl66

73515: END source_meaning
73516: FROM xla_events_gt xet
73517: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
73518: , fnd_lookup_values fvl7
73519: , fnd_lookup_values fvl66
73520: , fnd_lookup_values fvl67
73521: , fnd_lookup_values fvl85
73522: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
73523: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 73520: , fnd_lookup_values fvl67

73516: FROM xla_events_gt xet
73517: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
73518: , fnd_lookup_values fvl7
73519: , fnd_lookup_values fvl66
73520: , fnd_lookup_values fvl67
73521: , fnd_lookup_values fvl85
73522: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
73523: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73524: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 73521: , fnd_lookup_values fvl85

73517: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
73518: , fnd_lookup_values fvl7
73519: , fnd_lookup_values fvl66
73520: , fnd_lookup_values fvl67
73521: , fnd_lookup_values fvl85
73522: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
73523: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73524: AND xet.event_class_code = C_EVENT_CLASS_CODE
73525: AND l4.event_id = xet.event_id

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

73668: l_balance_type_code VARCHAR2(1) :=NULL;
73669: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
73670:
73671: --
73672: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
73673: --
73674:
73675: TYPE t_array_source_4 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;
73676: TYPE t_array_source_5 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 73798: , fnd_lookup_values fvl116

73794: , AR_BILL_TO_CUSTOMERS_S_V h1
73795: , AR_BILL_TO_SITE_USES_S_V h2
73796: , AR_TRANSACTIONS_S_V h3
73797: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
73798: , fnd_lookup_values fvl116
73799: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73800: and xet.event_class_code = C_EVENT_CLASS_CODE
73801: and xet.event_status_code <> 'N' AND h5.event_id = xet.event_id
73802: AND h1.event_id (+) = h5.event_id

Line 73873: , fnd_lookup_values fvl7

73869: , l4.JLBR_BANK_OCC_TYPE source_85
73870: , fvl85.meaning source_85_meaning
73871: FROM xla_events_gt xet
73872: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
73873: , fnd_lookup_values fvl7
73874: , fnd_lookup_values fvl66
73875: , fnd_lookup_values fvl67
73876: , fnd_lookup_values fvl85
73877: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 73874: , fnd_lookup_values fvl66

73870: , fvl85.meaning source_85_meaning
73871: FROM xla_events_gt xet
73872: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
73873: , fnd_lookup_values fvl7
73874: , fnd_lookup_values fvl66
73875: , fnd_lookup_values fvl67
73876: , fnd_lookup_values fvl85
73877: WHERE xet.event_id between x_first_event_id and x_last_event_id
73878: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 73875: , fnd_lookup_values fvl67

73871: FROM xla_events_gt xet
73872: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
73873: , fnd_lookup_values fvl7
73874: , fnd_lookup_values fvl66
73875: , fnd_lookup_values fvl67
73876: , fnd_lookup_values fvl85
73877: WHERE xet.event_id between x_first_event_id and x_last_event_id
73878: and xet.event_date between p_pad_start_date and p_pad_end_date
73879: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 73876: , fnd_lookup_values fvl85

73872: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
73873: , fnd_lookup_values fvl7
73874: , fnd_lookup_values fvl66
73875: , fnd_lookup_values fvl67
73876: , fnd_lookup_values fvl85
73877: WHERE xet.event_id between x_first_event_id and x_last_event_id
73878: and xet.event_date between p_pad_start_date and p_pad_end_date
73879: and xet.event_class_code = C_EVENT_CLASS_CODE
73880: and xet.event_status_code <> 'N' AND l4.event_id = xet.event_id

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

75283: l_balance_type_code VARCHAR2(1) :=NULL;
75284: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
75285:
75286: --
75287: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
75288: --
75289:
75290: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
75291: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

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

76544: l_balance_type_code VARCHAR2(1) :=NULL;
76545: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
76546:
76547: --
76548: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76549: --
76550:
76551: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76552: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

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

78131: l_balance_type_code VARCHAR2(1) :=NULL;
78132: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
78133:
78134: --
78135: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
78136: --
78137:
78138: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
78139: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

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

79770: l_balance_type_code VARCHAR2(1) :=NULL;
79771: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
79772:
79773: --
79774: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79775: --
79776:
79777: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79778: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;