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

Line 29195: , fnd_lookup_values fvl13

29191: , CST_XLA_RCV_REF_V h3
29192: , PO_DISTS_REF_V h5
29193: , PO_HEADERS_REF_V h6
29194: , PSA_CST_XLA_UPG_V h7
29195: , fnd_lookup_values fvl13
29196: , fnd_lookup_values fvl36
29197: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
29198: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29199: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 29196: , fnd_lookup_values fvl36

29192: , PO_DISTS_REF_V h5
29193: , PO_HEADERS_REF_V h6
29194: , PSA_CST_XLA_UPG_V h7
29195: , fnd_lookup_values fvl13
29196: , fnd_lookup_values fvl36
29197: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
29198: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29199: AND xet.event_class_code = C_EVENT_CLASS_CODE
29200: AND h1.event_id = xet.event_id

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

29499: l_balance_type_code VARCHAR2(1) :=NULL;
29500: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
29501:
29502: --
29503: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
29504: --
29505:
29506: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
29507: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 29628: , fnd_lookup_values fvl13

29624: , CST_XLA_RCV_REF_V h3
29625: , PO_DISTS_REF_V h5
29626: , PO_HEADERS_REF_V h6
29627: , PSA_CST_XLA_UPG_V h7
29628: , fnd_lookup_values fvl13
29629: , fnd_lookup_values fvl36
29630: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
29631: and xet.event_class_code = C_EVENT_CLASS_CODE
29632: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 29629: , fnd_lookup_values fvl36

29625: , PO_DISTS_REF_V h5
29626: , PO_HEADERS_REF_V h6
29627: , PSA_CST_XLA_UPG_V h7
29628: , fnd_lookup_values fvl13
29629: , fnd_lookup_values fvl36
29630: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
29631: and xet.event_class_code = C_EVENT_CLASS_CODE
29632: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
29633: AND h3.REF_RCV_ACCOUNTING_EVENT_ID = h1.RCV_ACCOUNTING_EVENT_ID AND h3.po_header_id = h5.po_header_id (+) AND h3.po_distribution_id = h5.po_distribution_id (+) AND h3.po_header_id = h6.po_header_id (+) AND h3.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 31321: , fnd_lookup_values fvl13

31317: , CST_XLA_INV_REF_V h3
31318: , PO_DISTS_REF_V h5
31319: , PO_HEADERS_REF_V h6
31320: , PSA_CST_XLA_UPG_V h7
31321: , fnd_lookup_values fvl13
31322: , fnd_lookup_values fvl36
31323: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
31324: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
31325: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 31322: , fnd_lookup_values fvl36

31318: , PO_DISTS_REF_V h5
31319: , PO_HEADERS_REF_V h6
31320: , PSA_CST_XLA_UPG_V h7
31321: , fnd_lookup_values fvl13
31322: , fnd_lookup_values fvl36
31323: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
31324: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
31325: AND xet.event_class_code = C_EVENT_CLASS_CODE
31326: AND h1.event_id = xet.event_id

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

31640: l_balance_type_code VARCHAR2(1) :=NULL;
31641: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
31642:
31643: --
31644: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
31645: --
31646:
31647: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
31648: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 31763: , fnd_lookup_values fvl13

31759: , CST_XLA_INV_REF_V h3
31760: , PO_DISTS_REF_V h5
31761: , PO_HEADERS_REF_V h6
31762: , PSA_CST_XLA_UPG_V h7
31763: , fnd_lookup_values fvl13
31764: , fnd_lookup_values fvl36
31765: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
31766: and xet.event_class_code = C_EVENT_CLASS_CODE
31767: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 31764: , fnd_lookup_values fvl36

31760: , PO_DISTS_REF_V h5
31761: , PO_HEADERS_REF_V h6
31762: , PSA_CST_XLA_UPG_V h7
31763: , fnd_lookup_values fvl13
31764: , fnd_lookup_values fvl36
31765: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
31766: and xet.event_class_code = C_EVENT_CLASS_CODE
31767: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
31768: AND h3.ref_transaction_id = h1.transaction_id AND h3.txn_po_header_id = h5.po_header_id (+) AND h3.txn_po_distribution_id = h5.po_distribution_id (+) AND h3.txn_po_header_id = h6.po_header_id (+) AND h3.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'