APPS.CSTPACOV dependencies on CST_ITEM_OVERHEAD_DEFAULTS

Line 127: FROM cst_item_overhead_defaults ciod,

123: DECODE(NVL(I_SHRINKAGE_RATE,-9),-9,1,
124: 1 / (1 - I_SHRINKAGE_RATE)),
125: 1, /* rollup soure type = user defined */
126: br.cost_element_id
127: FROM cst_item_overhead_defaults ciod,
128: bom_resources br
129: WHERE NOT EXISTS /* Don't insert if item already exists */
130: (SELECT /*+ INDEX(cicd CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147
131: 'X'

Line 143: FROM cst_item_overhead_defaults ciod2

139: ( category_id is NULL
140: AND item_type = 3 /* all items */
141: AND NOT EXISTS
142: (SELECT 'X'
143: FROM cst_item_overhead_defaults ciod2
144: WHERE category_set_id = p_category_set_id
145: AND organization_id = I_ORGANIZATION_ID
146: AND category_id = p_category_id
147: AND ciod2.material_overhead_id = ciod.material_overhead_id

Line 151: FROM cst_item_overhead_defaults ciod2

147: AND ciod2.material_overhead_id = ciod.material_overhead_id
148: AND item_type = I_ITEM_TYPE)
149: AND NOT EXISTS
150: (SELECT 'X'
151: FROM cst_item_overhead_defaults ciod2
152: WHERE category_set_id = p_category_set_id
153: AND organization_id = I_ORGANIZATION_ID
154: AND category_id = p_category_id
155: AND ciod2.material_overhead_id = ciod.material_overhead_id

Line 159: FROM cst_item_overhead_defaults ciod2

155: AND ciod2.material_overhead_id = ciod.material_overhead_id
156: AND item_type = 3)
157: AND NOT EXISTS
158: (SELECT 'X'
159: FROM cst_item_overhead_defaults ciod2
160: WHERE category_id is NULL
161: AND organization_id = I_ORGANIZATION_ID
162: AND ciod2.material_overhead_id = ciod.material_overhead_id
163: AND item_type = I_ITEM_TYPE)

Line 170: FROM cst_item_overhead_defaults ciod2

166: ( category_id is NULL
167: AND item_type = I_ITEM_TYPE
168: AND NOT EXISTS
169: (SELECT 'X'
170: FROM cst_item_overhead_defaults ciod2
171: WHERE category_set_id = p_category_set_id
172: AND organization_id = I_ORGANIZATION_ID
173: AND category_id = p_category_id
174: AND ciod2.material_overhead_id = ciod.material_overhead_id

Line 178: FROM cst_item_overhead_defaults ciod2

174: AND ciod2.material_overhead_id = ciod.material_overhead_id
175: AND item_type = I_ITEM_TYPE)
176: AND NOT EXISTS
177: (SELECT 'X'
178: FROM cst_item_overhead_defaults ciod2
179: WHERE category_set_id = p_category_set_id
180: AND organization_id = I_ORGANIZATION_ID
181: AND category_id = p_category_id
182: AND ciod2.material_overhead_id = ciod.material_overhead_id

Line 191: FROM cst_item_overhead_defaults ciod2

187: AND category_id = p_category_id
188: AND item_type = 3 /* all items */
189: AND NOT EXISTS
190: (SELECT 'X'
191: FROM cst_item_overhead_defaults ciod2
192: WHERE category_set_id = p_category_set_id
193: AND organization_id = I_ORGANIZATION_ID
194: AND category_id = p_category_id
195: AND ciod2.material_overhead_id = ciod.material_overhead_id