DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on CST_STANDARD_COSTS

Line 4040: FROM cst_standard_costs CSC,

4036: --get the cost update history ID after the end period call
4037:
4038: SELECT MIN(CSC.cost_update_id)
4039: INTO l_min_cost_update_id
4040: FROM cst_standard_costs CSC,
4041: mtl_parameters MP
4042: WHERE MP.organization_id = l_organization_id
4043: AND CSC.organization_id = MP.cost_organization_id
4044: AND CSC.inventory_item_id = l_inventory_item_id

Line 4059: FROM cst_standard_costs CSC,

4055: IF l_min_cost_update_id IS NOT NULL THEN
4056: -- Yes. Figure out the prior cost update
4057: SELECT MAX(CSC.cost_update_id)
4058: INTO l_max_cost_update_id
4059: FROM cst_standard_costs CSC,
4060: mtl_parameters MP
4061: WHERE MP.organization_id = l_organization_id
4062: AND CSC.organization_id = MP.cost_organization_id
4063: AND CSC.inventory_item_id = l_inventory_item_id

Line 4071: FROM cst_standard_costs CSC,

4067: DECLARE
4068: CURSOR csc_cur
4069: IS
4070: SELECT CSC.cost_update_id
4071: FROM cst_standard_costs CSC,
4072: mtl_parameters MP
4073: WHERE MP.organization_id = l_organization_id
4074: AND CSC.organization_id = MP.cost_organization_id
4075: AND CSC.inventory_item_id = l_inventory_item_id