APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_PAC_INTORG_ITMS_TEMP

Line 3479: -- by validating against CST_PAC_INTORG_ITMS_TEMP table

3475:
3476: --=========================================================================
3477: -- FUNCTION : Check_For_No_Interorg_CG PRIVATE
3478: -- COMMENT : This function checks for non interorg cost groups
3479: -- by validating against CST_PAC_INTORG_ITMS_TEMP table
3480: -- CST_PAC_INTORG_ITMS_TEMP contains inventory items and Cost
3481: -- Groups which have only valid interorg txns across cost groups
3482: -- Cost Groups which have no vaid interorg txns are NOT present
3483: -- in this table

Line 3480: -- CST_PAC_INTORG_ITMS_TEMP contains inventory items and Cost

3476: --=========================================================================
3477: -- FUNCTION : Check_For_No_Interorg_CG PRIVATE
3478: -- COMMENT : This function checks for non interorg cost groups
3479: -- by validating against CST_PAC_INTORG_ITMS_TEMP table
3480: -- CST_PAC_INTORG_ITMS_TEMP contains inventory items and Cost
3481: -- Groups which have only valid interorg txns across cost groups
3482: -- Cost Groups which have no vaid interorg txns are NOT present
3483: -- in this table
3484: -- This function is used to get those non-interorg cost groups

Line 3503: FROM CST_PAC_INTORG_ITMS_TEMP

3499: ,c_inventory_item_id NUMBER
3500: )
3501: IS
3502: SELECT 'X'
3503: FROM CST_PAC_INTORG_ITMS_TEMP
3504: WHERE pac_period_id = c_pac_period_id
3505: AND cost_group_id = c_cost_group_id
3506: AND inventory_item_id = c_inventory_item_id;
3507:

Line 3720: UPDATE CST_PAC_INTORG_ITMS_TEMP cpiit

3716: ,p_period_end_date => p_end_date
3717: );
3718:
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

Line 3836: cst_pac_intorg_itms_temp

3832: SELECT count(1)
3833: INTO
3834: l_interorg_item_flag
3835: FROM
3836: cst_pac_intorg_itms_temp
3837: WHERE inventory_item_id = l_inventory_item_id
3838: AND pac_period_id = p_period_id
3839: AND absorption_level_code = l_current_level_code
3840: AND rownum = 1;

Line 3873: cst_pac_intorg_itms_temp

3869: -- l_wip_assembly_process_flag indicates whether wip completion txns are already processed or not
3870: SELECT decode(max(iteration_count), 0, 'N', 'Y')
3871: INTO l_assembly_processed_flag
3872: FROM
3873: cst_pac_intorg_itms_temp
3874: WHERE pac_period_id = p_period_id
3875: AND absorption_level_code = l_current_level_code
3876: AND inventory_item_id = l_inventory_item_id;
3877:

Line 3966: -- Table: CST_PAC_INTORG_ITMS_TEMP contains inventory items of

3962: -- change transactions, even though the interorg flag is 1 which
3963: -- indicates a presence of an interorg txn in any of the cost groups.
3964: -- Therefore, if l_interorg_item_flag is 1, check for
3965: -- non-interorg cost group to process for PCU - value change txns.
3966: -- Table: CST_PAC_INTORG_ITMS_TEMP contains inventory items of
3967: -- those cost groups having only valid interorg txns or scenario with
3968: -- FOB:shipment
3969: -- Cost groups having no valid interorg txns do not exist in the
3970: -- interorg table and therefore cannot get processed in the

Line 4249: FROM cst_pac_intorg_itms_temp

4245: -- check the tolerance for an interorg item
4246: -- l_tol_item_flag "Tolerance Not achieved for atleast one CG" = 1 "Tolerance achieved for all CGs" = 0
4247: SELECT count(1)
4248: INTO l_tol_item_flag
4249: FROM cst_pac_intorg_itms_temp
4250: WHERE pac_period_id = p_period_id
4251: AND inventory_item_id = l_inventory_item_id
4252: AND tolerance_flag = 'N'
4253: AND rownum = 1;

Line 4404: FROM cst_pac_intorg_itms_temp

4400: -- =====================================================================
4401:
4402: SELECT count(1)
4403: INTO l_tolerance_flag
4404: FROM cst_pac_intorg_itms_temp
4405: WHERE pac_period_id = p_period_id
4406: AND tolerance_flag = 'N'
4407: AND rownum = 1;
4408: