APPS.CSTPACOV dependencies on CST_ITEM_OVERHEAD_DEFAULTS

Line 108: FROM cst_item_overhead_defaults ciod,

104: DECODE(NVL(I_SHRINKAGE_RATE,-9),-9,1,
105: 1 / (1 - I_SHRINKAGE_RATE)),
106: 1, /* rollup soure type = user defined */
107: br.cost_element_id
108: FROM cst_item_overhead_defaults ciod,
109: bom_resources br
110: WHERE NOT EXISTS /* Don't insert if item already exists */
111: (SELECT /*+ INDEX(cicd CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147
112: 'X'

Line 124: FROM cst_item_overhead_defaults ciod2

120: ( category_id is NULL
121: AND item_type = 3 /* all items */
122: AND NOT EXISTS
123: (SELECT 'X'
124: FROM cst_item_overhead_defaults ciod2
125: WHERE category_set_id = p_category_set_id
126: AND organization_id = I_ORGANIZATION_ID
127: AND category_id = p_category_id
128: AND ciod2.material_overhead_id = ciod.material_overhead_id

Line 132: FROM cst_item_overhead_defaults ciod2

128: AND ciod2.material_overhead_id = ciod.material_overhead_id
129: AND item_type = I_ITEM_TYPE)
130: AND NOT EXISTS
131: (SELECT 'X'
132: FROM cst_item_overhead_defaults ciod2
133: WHERE category_set_id = p_category_set_id
134: AND organization_id = I_ORGANIZATION_ID
135: AND category_id = p_category_id
136: AND ciod2.material_overhead_id = ciod.material_overhead_id

Line 140: FROM cst_item_overhead_defaults ciod2

136: AND ciod2.material_overhead_id = ciod.material_overhead_id
137: AND item_type = 3)
138: AND NOT EXISTS
139: (SELECT 'X'
140: FROM cst_item_overhead_defaults ciod2
141: WHERE category_id is NULL
142: AND organization_id = I_ORGANIZATION_ID
143: AND ciod2.material_overhead_id = ciod.material_overhead_id
144: AND item_type = I_ITEM_TYPE)

Line 151: FROM cst_item_overhead_defaults ciod2

147: ( category_id is NULL
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 = I_ITEM_TYPE)
157: AND NOT EXISTS
158: (SELECT 'X'
159: FROM cst_item_overhead_defaults ciod2
160: WHERE category_set_id = p_category_set_id
161: AND organization_id = I_ORGANIZATION_ID
162: AND category_id = p_category_id
163: AND ciod2.material_overhead_id = ciod.material_overhead_id

Line 172: FROM cst_item_overhead_defaults ciod2

168: AND category_id = p_category_id
169: AND item_type = 3 /* all items */
170: AND NOT EXISTS
171: (SELECT 'X'
172: FROM cst_item_overhead_defaults ciod2
173: WHERE category_set_id = p_category_set_id
174: AND organization_id = I_ORGANIZATION_ID
175: AND category_id = p_category_id
176: AND ciod2.material_overhead_id = ciod.material_overhead_id