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.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_PAC_ITMS_ABSL_CODES

Line 2731: FROM cst_pac_itms_absl_codes

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

Line 2745: FROM cst_pac_itms_absl_codes cpiac, MTL_SYSTEM_ITEMS_B_KFV mst

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

Line 2772: -- Purge cst_pac_itms_absl_codes

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

Line 2773: DELETE cst_pac_itms_absl_codes

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

Line 2776: INSERT INTO cst_pac_itms_absl_codes

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

Line 2826: INSERT INTO cst_pac_itms_absl_codes

2822:
2823: -- Any completion item exists
2824: IF l_topmost_bom_level_code < 1000 THEN
2825:
2826: INSERT INTO cst_pac_itms_absl_codes
2827: (pac_period_id
2828: ,inventory_item_id
2829: ,absorption_level_code
2830: ,process_flag

Line 2857: FROM cst_pac_itms_absl_codes

2853:
2854: -- Retrieve topmost absorption level code
2855: SELECT min(absorption_level_code)
2856: INTO l_topmost_absl_level_code
2857: FROM cst_pac_itms_absl_codes
2858: WHERE pac_period_id = p_period_id;
2859:
2860: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2861: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

Line 2935: FROM cst_pac_itms_absl_codes cpiac

2931: -- than all of its child items
2932: -- ==================================================================================================
2933: SELECT min(cpiac.absorption_level_code) min_child_absl_level_code
2934: INTO l_min_child_absl_level_code
2935: FROM cst_pac_itms_absl_codes cpiac
2936: WHERE cpiac.pac_period_id = p_period_id
2937: AND cpiac.inventory_item_id IN (SELECT DISTINCT cpet.component_item_id
2938: FROM cst_pac_explosion_temp cpet
2939: WHERE cpet.pac_period_id = cpiac.pac_period_id

Line 2965: UPDATE CST_PAC_ITMS_ABSL_CODES

2961: ,'Reposition Absorption Level Code:' || l_reposition_absl_level_code || ' Item Id:' || items_in_current_absl_row.inventory_item_id
2962: );
2963: END IF;
2964:
2965: UPDATE CST_PAC_ITMS_ABSL_CODES
2966: SET absorption_level_code = l_reposition_absl_level_code
2967: WHERE CURRENT OF items_in_current_absl_cur;
2968: l_continue_loop_flag := 'Y';
2969: END IF;

Line 3465: FROM cst_pac_itms_absl_codes

3461: )
3462: IS
3463: SELECT
3464: inventory_item_id
3465: FROM cst_pac_itms_absl_codes
3466: WHERE pac_period_id = c_pac_period_id
3467: AND absorption_level_code = c_absorption_level_code
3468: AND process_flag = 'N';
3469:

Line 3577: FROM cst_pac_itms_absl_codes

3573: -- Assign Absorption Level Code to Interorg Items
3574: UPDATE CST_PAC_INTORG_ITMS_TEMP cpiit
3575: SET cpiit.absorption_level_code =
3576: (SELECT absorption_level_code
3577: FROM cst_pac_itms_absl_codes
3578: WHERE pac_period_id = cpiit.pac_period_id
3579: AND inventory_item_id = cpiit.inventory_item_id
3580: )
3581: WHERE cpiit.pac_period_id = p_period_id;

Line 3605: FROM cst_pac_itms_absl_codes

3601: -- NOTE: for no completion items topmost absorption level code will be 1000
3602: -- ========================================================================
3603: SELECT NVL(min(absorption_level_code),1000)
3604: INTO l_topmost_absl_level_code
3605: FROM cst_pac_itms_absl_codes
3606: WHERE pac_period_id = p_period_id;
3607:
3608: -- ========================================
3609: -- initialize the starting Absorption level

Line 3617: FROM cst_pac_itms_absl_codes

3613: IF p_run_options = 3 OR p_run_options = 4 THEN
3614:
3615: SELECT NVL(max(absorption_level_code),1000)
3616: INTO l_lowest_absl_level_code
3617: FROM cst_pac_itms_absl_codes
3618: WHERE pac_period_id = p_period_id
3619: AND process_flag = 'N';
3620: ELSE
3621: -- run options 1 - start or 2 - error

Line 3941: UPDATE CST_PAC_ITMS_ABSL_CODES

3937: );
3938:
3939: -- Set the process flag to Y after processing
3940: -- other cost derived txns - group 2
3941: UPDATE CST_PAC_ITMS_ABSL_CODES
3942: SET process_flag = 'Y'
3943: WHERE pac_period_id = p_period_id
3944: AND inventory_item_id = l_inventory_item_id
3945: AND absorption_level_code = l_current_level_code;