APPS.JA_JAINYEDE_XMLP_PKG dependencies on FA_MASS_ADDITIONS

Line 2707: FA_MASS_ADDITIONS A,

2703: ,B.START_DATE) AQUISATION_DATE,
2704: D.DATE_PLACED_IN_SERVICE,
2705: A.FIXED_ASSETS_UNITS
2706: FROM
2707: FA_MASS_ADDITIONS A,
2708: JAI_FA_AST_BLOCKS B,
2709: JAI_FA_AST_PERIOD_RATES C,
2710: FA_BOOKS D
2711: WHERE NVL(A.MASS_ADDITION_ID

Line 2734: FA_MASS_ADDITIONS A,

2730: CURSOR COUNT_CUR(P_BLOCK_ID IN NUMBER) IS
2731: SELECT
2732: count(*)
2733: FROM
2734: FA_MASS_ADDITIONS A,
2735: JAI_FA_AST_BLOCKS B,
2736: JAI_FA_AST_PERIOD_RATES C,
2737: FA_BOOKS D
2738: WHERE NVL(A.MASS_ADDITION_ID

Line 2769: FA_MASS_ADDITIONS B,

2765: NVL(SUM(C.PROCEEDS_OF_SALE - C.COST_OF_REMOVAL)
2766: ,0) SALE
2767: FROM
2768: JAI_FA_AST_BLOCKS A,
2769: FA_MASS_ADDITIONS B,
2770: FA_RETIREMENTS C
2771: WHERE A.BLOCK_ID = B.ATTRIBUTE2
2772: AND A.BOOK_TYPE_CODE = P_BOOK_NAME
2773: AND B.MASS_ADDITION_ID = C.ASSET_ID

Line 2786: FA_MASS_ADDITIONS B,

2782: SUM(NVL(A.PROCEEDS_OF_SALE
2783: ,0)) SALE
2784: FROM
2785: FA_RETIREMENTS A,
2786: FA_MASS_ADDITIONS B,
2787: JAI_FA_AST_BLOCKS C
2788: WHERE A.ASSET_ID = B.MASS_ADDITION_ID
2789: AND B.ATTRIBUTE2 = P_BLOCK_ID
2790: AND B.ATTRIBUTE2 = C.BLOCK_ID

Line 2803: FA_MASS_ADDITIONS B

2799: A.ASSET_ID,
2800: A.DATE_PLACED_IN_SERVICE
2801: FROM
2802: FA_BOOKS A,
2803: FA_MASS_ADDITIONS B
2804: WHERE A.ASSET_ID = P_ASSET_ID
2805: AND A.ASSET_ID = B.MASS_ADDITION_ID
2806: AND A.DATE_INEFFECTIVE is null
2807: AND A.TRANSACTION_HEADER_ID_OUT is null

Line 2828: FA_MASS_ADDITIONS B

2824: A.ASSET_ID,
2825: A.DATE_PLACED_IN_SERVICE
2826: FROM
2827: FA_BOOKS A,
2828: FA_MASS_ADDITIONS B
2829: WHERE A.ASSET_ID = P_ASSET_ID
2830: AND A.ASSET_ID = B.MASS_ADDITION_ID
2831: AND A.DATE_INEFFECTIVE is null
2832: AND A.TRANSACTION_HEADER_ID_OUT is null

Line 2886: FA_MASS_ADDITIONS B

2882: A.UNITS,
2883: TO_NUMBER(B.ATTRIBUTE2)
2884: FROM
2885: FA_RETIREMENTS A,
2886: FA_MASS_ADDITIONS B
2887: WHERE A.DATE_RETIRED <= P_YEAR_END
2888: AND A.ASSET_ID = B.MASS_ADDITION_ID
2889: AND A.STATUS = 'PROCESSED'
2890: AND A.ASSET_ID = P_ASSET_ID

Line 2899: FA_MASS_ADDITIONS A

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)
2903: FROM

Line 2920: FA_MASS_ADDITIONS )

2916: SELECT
2917: TO_NUMBER(NVL(ATTRIBUTE2
2918: ,0))
2919: FROM
2920: FA_MASS_ADDITIONS )
2921: AND START_DATE >= P_YEAR_START
2922: AND START_DATE <= P_YEAR_END;
2923: CURSOR CLOSING_BALANCE_CUR(P_BLOCK_ID IN NUMBER) IS
2924: SELECT

Line 2964: FA_MASS_ADDITIONS B,

2960: SELECT
2961: count(*)
2962: FROM
2963: FA_RETIREMENTS A,
2964: FA_MASS_ADDITIONS B,
2965: JAI_FA_AST_BLOCKS C
2966: WHERE A.DATE_RETIRED BETWEEN P_YEAR_START
2967: AND P_YEAR_END
2968: AND A.ASSET_ID = B.MASS_ADDITION_ID

Line 2976: FA_MASS_ADDITIONS

2972: CURSOR ASSET_ID_CURSOR(P_BLOCK_ID IN NUMBER) IS
2973: SELECT
2974: MASS_ADDITION_ID
2975: FROM
2976: FA_MASS_ADDITIONS
2977: WHERE ATTRIBUTE2 = P_BLOCK_ID;
2978: CURSOR OPENING_WDV_ADJ_CUR IS
2979: SELECT
2980: RATE,

Line 3003: FA_MASS_ADDITIONS );

2999: AND BLOCK_ID in (
3000: SELECT
3001: TO_NUMBER(ATTRIBUTE2)
3002: FROM
3003: FA_MASS_ADDITIONS );
3004: CURSOR ADJUST_OPEN_CUR(P_RATE IN NUMBER,P_TYPE IN VARCHAR2) IS
3005: SELECT
3006: BLOCK_ID,
3007: OPENING_WDV,