APPS.OPIMPXWI dependencies on CST_STANDARD_COSTS

Line 87: 1. Get the historical item cost from the csc (cst_standard_costs)

83: we get the wrong cost from the actual_cost column of mcacd
84: as the starting cost for the collection program.
85:
86: To correct this, we need to do the following:
87: 1. Get the historical item cost from the csc (cst_standard_costs)
88: table. This table has the historical costs after an SCU is
89: made. We just need the latest cost prior to the start date.
90: If there is more than one SCU on the same day, use the latest
91: cost on that day.

Line 119: -- Cursor to get the historical cost from the cst_standard_costs (csc)

115:
116: -- procedure name
117: proc_name VARCHAR2(30) := 'std_costing_org_item_cost';
118:
119: -- Cursor to get the historical cost from the cst_standard_costs (csc)
120: -- table. Need the latest cost in the csc prior to the given date
121: CURSOR latest_csc_cost_to_date_cur (p_org_id NUMBER, p_item_id NUMBER,
122: p_cost_date DATE)
123: IS

Line 125: FROM cst_standard_costs csc

121: CURSOR latest_csc_cost_to_date_cur (p_org_id NUMBER, p_item_id NUMBER,
122: p_cost_date DATE)
123: IS
124: SELECT csc.standard_cost unit_cost
125: FROM cst_standard_costs csc
126: WHERE csc.organization_id = p_org_id
127: AND csc.inventory_item_id = p_item_id
128: AND csc.standard_cost_revision_date =
129: (SELECT max(csc2.standard_cost_revision_date)

Line 130: FROM cst_standard_costs csc2

126: WHERE csc.organization_id = p_org_id
127: AND csc.inventory_item_id = p_item_id
128: AND csc.standard_cost_revision_date =
129: (SELECT max(csc2.standard_cost_revision_date)
130: FROM cst_standard_costs csc2
131: WHERE csc2.organization_id = p_org_id
132: AND csc2.inventory_item_id = p_item_id
133: AND csc2.standard_cost_revision_date <
134: trunc(p_cost_date) + 1);

Line 148: FROM cst_standard_costs csc

144: CURSOR all_csc_costs_post_date_cur (p_org_id NUMBER, p_item_id NUMBER,
145: p_cost_date DATE)
146: IS
147: SELECT csc.standard_cost unit_cost
148: FROM cst_standard_costs csc
149: WHERE csc.organization_id = p_org_id
150: AND csc.inventory_item_id = p_item_id;
151:
152: -- Cursor to get the historical item cost from the