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.JA_JAINYEDE_XMLP_PKG dependencies on FA_ASSET_HISTORY

Line 888: FA_ASSET_HISTORY H,

884: DISTINCT
885: H.UNITS,
886: H.ASSET_ID
887: FROM
888: FA_ASSET_HISTORY H,
889: JAI_FA_AST_BLOCK_DTLS A
890: WHERE TRANSACTION_HEADER_ID_IN IN (
891: SELECT
892: MIN(TRANSACTION_HEADER_ID_IN)

Line 894: FA_ASSET_HISTORY

890: WHERE TRANSACTION_HEADER_ID_IN IN (
891: SELECT
892: MIN(TRANSACTION_HEADER_ID_IN)
893: FROM
894: FA_ASSET_HISTORY
895: GROUP BY
896: ASSET_ID )
897: AND A.ASSET_ID = H.ASSET_ID
898: AND A.BLOCK_ID = P_BLOCK_ID

Line 1467: FA_ASSET_HISTORY H,

1463: DISTINCT
1464: H.UNITS,
1465: H.ASSET_ID
1466: FROM
1467: FA_ASSET_HISTORY H,
1468: JAI_FA_AST_BLOCK_DTLS A
1469: WHERE H.TRANSACTION_HEADER_ID_IN IN (
1470: SELECT
1471: MIN(TRANSACTION_HEADER_ID_IN)

Line 1473: FA_ASSET_HISTORY

1469: WHERE H.TRANSACTION_HEADER_ID_IN IN (
1470: SELECT
1471: MIN(TRANSACTION_HEADER_ID_IN)
1472: FROM
1473: FA_ASSET_HISTORY
1474: GROUP BY
1475: ASSET_ID )
1476: AND A.ASSET_ID = H.ASSET_ID
1477: AND A.BLOCK_ID = P_BLOCK_ID

Line 2898: FA_ASSET_HISTORY H,

2894: DISTINCT
2895: H.UNITS,
2896: H.ASSET_ID
2897: FROM
2898: FA_ASSET_HISTORY H,
2899: FA_MASS_ADDITIONS A
2900: WHERE TRANSACTION_HEADER_ID_IN IN (
2901: SELECT
2902: MIN(TRANSACTION_HEADER_ID_IN)

Line 2904: FA_ASSET_HISTORY

2900: WHERE TRANSACTION_HEADER_ID_IN IN (
2901: SELECT
2902: MIN(TRANSACTION_HEADER_ID_IN)
2903: FROM
2904: FA_ASSET_HISTORY
2905: GROUP BY
2906: ASSET_ID )
2907: AND A.MASS_ADDITION_ID = H.ASSET_ID
2908: AND A.ATTRIBUTE2 = P_BLOCK_ID