DBA Data[Home] [Help]

APPS.CSD_COST_ANALYSIS_PVT dependencies on CST_ITEM_COSTS

Line 876: FROM CST_ITEM_COSTS CIC

872: CURSOR cur_getItemCost(p_inventory_item_id NUMBER,
873: p_organization_id NUMBER)
874: IS
875: SELECT CIC.item_cost
876: FROM CST_ITEM_COSTS CIC
877: WHERE CIC.inventory_item_id = p_inventory_item_id
878: AND CIC.organization_id = p_organization_id
879: AND CIC.cost_type_id = 1; -- standard/frozen cost
880:

Line 1165: FROM CST_ITEM_COSTS CIC

1161: CURSOR cur_getItemCost(p_inventory_item_id NUMBER,
1162: p_organization_id NUMBER)
1163: IS
1164: SELECT CIC.item_cost
1165: FROM CST_ITEM_COSTS CIC
1166: WHERE CIC.inventory_item_id = p_inventory_item_id
1167: AND CIC.organization_id = p_organization_id
1168: AND CIC.cost_type_id = 1; -- standard/frozen cost
1169: