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.

[Home] [Help]

APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_PAC_ITMS_ABSL_CODES

Line 2729: FROM cst_pac_itms_absl_codes

2725: )
2726: IS
2727: SELECT
2728: inventory_item_id
2729: FROM cst_pac_itms_absl_codes
2730: WHERE pac_period_id = c_pac_period_id
2731: AND absorption_level_code = c_absorption_level_code
2732: FOR UPDATE OF absorption_level_code;
2733:

Line 2743: FROM cst_pac_itms_absl_codes cpiac, MTL_SYSTEM_ITEMS_B_KFV mst

2739: ,c_absorption_level_code NUMBER
2740: )
2741: IS
2742: SELECT distinct(mst.concatenated_segments)
2743: FROM cst_pac_itms_absl_codes cpiac, MTL_SYSTEM_ITEMS_B_KFV mst
2744: WHERE cpiac.pac_period_id = c_pac_period_id
2745: AND cpiac.absorption_level_code < c_absorption_level_code
2746: AND cpiac.inventory_item_id = mst.inventory_item_id;
2747:

Line 2770: -- Purge cst_pac_itms_absl_codes

2766: ,l_routine || '<'
2767: );
2768: END IF;
2769:
2770: -- Purge cst_pac_itms_absl_codes
2771: DELETE cst_pac_itms_absl_codes
2772: WHERE pac_period_id = p_period_id;
2773:
2774: INSERT INTO cst_pac_itms_absl_codes

Line 2771: DELETE cst_pac_itms_absl_codes

2767: );
2768: END IF;
2769:
2770: -- Purge cst_pac_itms_absl_codes
2771: DELETE cst_pac_itms_absl_codes
2772: WHERE pac_period_id = p_period_id;
2773:
2774: INSERT INTO cst_pac_itms_absl_codes
2775: (inventory_item_id

Line 2774: INSERT INTO cst_pac_itms_absl_codes

2770: -- Purge cst_pac_itms_absl_codes
2771: DELETE cst_pac_itms_absl_codes
2772: WHERE pac_period_id = p_period_id;
2773:
2774: INSERT INTO cst_pac_itms_absl_codes
2775: (inventory_item_id
2776: ,pac_period_id
2777: ,absorption_level_code
2778: ,process_flag

Line 2881: INSERT INTO cst_pac_itms_absl_codes

2877:
2878: -- Any completion item exists
2879: IF l_topmost_bom_level_code <= 1000 THEN
2880:
2881: INSERT INTO cst_pac_itms_absl_codes
2882: (pac_period_id
2883: ,inventory_item_id
2884: ,absorption_level_code
2885: ,process_flag

Line 2912: FROM cst_pac_itms_absl_codes

2908:
2909: -- Retrieve topmost absorption level code
2910: SELECT min(absorption_level_code)
2911: INTO l_topmost_absl_level_code
2912: FROM cst_pac_itms_absl_codes
2913: WHERE pac_period_id = p_period_id;
2914:
2915: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2916: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

Line 2990: FROM cst_pac_itms_absl_codes cpiac

2986: -- than all of its child items
2987: -- ==================================================================================================
2988: SELECT min(cpiac.absorption_level_code) min_child_absl_level_code
2989: INTO l_min_child_absl_level_code
2990: FROM cst_pac_itms_absl_codes cpiac
2991: WHERE cpiac.pac_period_id = p_period_id
2992: AND cpiac.inventory_item_id IN (SELECT DISTINCT cpet.component_item_id
2993: FROM cst_pac_explosion_temp cpet
2994: WHERE cpet.pac_period_id = cpiac.pac_period_id

Line 3020: UPDATE CST_PAC_ITMS_ABSL_CODES

3016: ,'Reposition Absorption Level Code:' || l_reposition_absl_level_code || ' Item Id:' || items_in_current_absl_row.inventory_item_id
3017: );
3018: END IF;
3019:
3020: UPDATE CST_PAC_ITMS_ABSL_CODES
3021: SET absorption_level_code = l_reposition_absl_level_code
3022: WHERE CURRENT OF items_in_current_absl_cur;
3023: l_continue_loop_flag := 'Y';
3024: END IF;

Line 3603: FROM cst_pac_itms_absl_codes

3599: )
3600: IS
3601: SELECT
3602: inventory_item_id
3603: FROM cst_pac_itms_absl_codes
3604: WHERE pac_period_id = c_pac_period_id
3605: AND absorption_level_code = c_absorption_level_code
3606: AND process_flag = 'N';
3607:

Line 3723: FROM cst_pac_itms_absl_codes

3719: -- Assign Absorption Level Code to Interorg Items
3720: UPDATE CST_PAC_INTORG_ITMS_TEMP cpiit
3721: SET cpiit.absorption_level_code =
3722: (SELECT absorption_level_code
3723: FROM cst_pac_itms_absl_codes
3724: WHERE pac_period_id = cpiit.pac_period_id
3725: AND inventory_item_id = cpiit.inventory_item_id
3726: )
3727: WHERE cpiit.pac_period_id = p_period_id;

Line 3751: FROM cst_pac_itms_absl_codes

3747: -- NOTE: for no completion items topmost absorption level code will be 1000
3748: -- ========================================================================
3749: SELECT NVL(min(absorption_level_code),1000)
3750: INTO l_topmost_absl_level_code
3751: FROM cst_pac_itms_absl_codes
3752: WHERE pac_period_id = p_period_id;
3753:
3754: -- ========================================
3755: -- initialize the starting Absorption level

Line 3763: FROM cst_pac_itms_absl_codes

3759: IF p_run_options = 3 OR p_run_options = 4 THEN
3760:
3761: SELECT NVL(max(absorption_level_code),1000)
3762: INTO l_lowest_absl_level_code
3763: FROM cst_pac_itms_absl_codes
3764: WHERE pac_period_id = p_period_id
3765: AND process_flag = 'N';
3766: ELSE
3767: -- run options 1 - start or 2 - error

Line 4310: UPDATE CST_PAC_ITMS_ABSL_CODES

4306: );
4307:
4308: -- Set the process flag to Y after processing
4309: -- other cost derived txns - group 2
4310: UPDATE CST_PAC_ITMS_ABSL_CODES
4311: SET process_flag = 'Y'
4312: WHERE pac_period_id = p_period_id
4313: AND inventory_item_id = l_inventory_item_id
4314: AND absorption_level_code = l_current_level_code;