APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_PAC_INTORG_ITMS_TEMP

Line 3574: UPDATE CST_PAC_INTORG_ITMS_TEMP cpiit

3570: ,p_period_end_date => p_end_date
3571: );
3572:
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

Line 3690: cst_pac_intorg_itms_temp

3686: SELECT count(1)
3687: INTO
3688: l_interorg_item_flag
3689: FROM
3690: cst_pac_intorg_itms_temp
3691: WHERE inventory_item_id = l_inventory_item_id
3692: AND pac_period_id = p_period_id
3693: AND absorption_level_code = l_current_level_code
3694: AND rownum = 1;

Line 3727: cst_pac_intorg_itms_temp

3723: -- l_wip_assembly_process_flag indicates whether wip completion txns are already processed or not
3724: SELECT decode(max(iteration_count), 0, 'N', 'Y')
3725: INTO l_assembly_processed_flag
3726: FROM
3727: cst_pac_intorg_itms_temp
3728: WHERE pac_period_id = p_period_id
3729: AND absorption_level_code = l_current_level_code
3730: AND inventory_item_id = l_inventory_item_id;
3731:

Line 3882: FROM cst_pac_intorg_itms_temp

3878: -- check the tolerance for an interorg item
3879: -- l_tol_item_flag "Tolerance Not achieved for atleast one CG" = 1 "Tolerance achieved for all CGs" = 0
3880: SELECT count(1)
3881: INTO l_tol_item_flag
3882: FROM cst_pac_intorg_itms_temp
3883: WHERE pac_period_id = p_period_id
3884: AND inventory_item_id = l_inventory_item_id
3885: AND tolerance_flag = 'N'
3886: AND rownum = 1;

Line 4035: FROM cst_pac_intorg_itms_temp

4031: -- =====================================================================
4032:
4033: SELECT count(1)
4034: INTO l_tolerance_flag
4035: FROM cst_pac_intorg_itms_temp
4036: WHERE pac_period_id = p_period_id
4037: AND tolerance_flag = 'N'
4038: AND rownum = 1;
4039: