APPS.CTO_CONFIG_ITEM_PK dependencies on CST_ITEM_COST_DETAILS

Line 6561: cst_item_cost_details CICD,

6557: l_rt_cicd_summary.overhead_cost
6558: from
6559: mtl_parameters MP1,
6560: cst_item_costs C,
6561: cst_item_cost_details CICD,
6562: mtl_system_items S -- 4172300
6563: where S.organization_id = C.organization_id
6564: and S.inventory_item_id = C.inventory_item_id
6565: and C.organization_id = MP1.organization_id

Line 7022: Insert rows into the cst_item_cost_details table

7018:
7019:
7020:
7021: /*------ ----------------------------------------------+
7022: Insert rows into the cst_item_cost_details table
7023: +-----------------------------------------------------*/
7024:
7025: lStmtNumber := 230;
7026:

Line 7027: insert into cst_item_cost_details

7023: +-----------------------------------------------------*/
7024:
7025: lStmtNumber := 230;
7026:
7027: insert into cst_item_cost_details
7028: (inventory_item_id,
7029: cost_type_id,
7030: last_update_date,
7031: last_updated_by,

Line 7118: cst_item_cost_details C,

7114: C.attribute14,
7115: C.attribute15
7116: from
7117: mtl_parameters MP1,
7118: cst_item_cost_details C,
7119: mtl_system_items S,
7120: bom_cto_src_orgs bcso
7121: where S.organization_id = C.organization_id
7122: and S.inventory_item_id = C.inventory_item_id

Line 7133: from cst_item_cost_details

7129: and C.COST_TYPE_ID IN ( MP1.primary_cost_method, MP1.avg_rates_cost_type_id)
7130: and mp1.organization_id = bcso.organization_id
7131: and NOT EXISTS
7132: (select NULL
7133: from cst_item_cost_details
7134: where inventory_item_id = pConfigId
7135: and organization_id = mp1.organization_id
7136: and COST_TYPE_ID IN (MP1.primary_cost_method, MP1.avg_rates_cost_type_id));
7137:

Line 7141: oe_debug_pub.add('Create_Item: ' || 'after insert:cst_item_cost_details inserted '||to_char(sql%rowcount),2);

7137:
7138:
7139:
7140: IF PG_DEBUG <> 0 THEN
7141: oe_debug_pub.add('Create_Item: ' || 'after insert:cst_item_cost_details inserted '||to_char(sql%rowcount),2);
7142: END IF;
7143:
7144:
7145:

Line 7151: insert into cst_item_cost_details

7147:
7148: /* For standard costing orgs, we will copy model's user-defined
7149: cost in Frozen to the config in CTO cost type. */
7150:
7151: insert into cst_item_cost_details
7152: (inventory_item_id,
7153: cost_type_id,
7154: last_update_date,
7155: last_updated_by,

Line 7242: cst_item_cost_details C,

7238: C.attribute14,
7239: C.attribute15
7240: from
7241: mtl_parameters MP1,
7242: cst_item_cost_details C,
7243: mtl_system_items S,
7244: bom_cto_src_orgs bcso
7245: where S.organization_id = C.organization_id
7246: and S.inventory_item_id = C.inventory_item_id

Line 7258: from cst_item_cost_details

7254: and C.cost_type_id = 1
7255: and mp1.organization_id = bcso.organization_id
7256: and NOT EXISTS
7257: (select NULL
7258: from cst_item_cost_details
7259: where inventory_item_id = pConfigId
7260: and organization_id = mp1.organization_id
7261: and COST_TYPE_ID = l_cto_cost_type_id);
7262:

Line 7347: FROM cst_item_cost_details

7343: -1,
7344: -1,
7345: SYSDATE,
7346: NVL(SUM(item_cost),0)
7347: FROM cst_item_cost_details
7348: WHERE ORGANIZATION_ID = v_organization_id
7349: AND INVENTORY_ITEM_ID = pConfigId
7350: AND COST_TYPE_ID = 1;
7351:

Line 7380: FROM cst_item_cost_details

7376: SYSDATE,
7377: -1,
7378: -1,
7379: NVL(SUM(item_cost),0)
7380: FROM cst_item_cost_details
7381: WHERE ORGANIZATION_ID = v_organization_id
7382: AND INVENTORY_ITEM_ID = pConfigId
7383: AND COST_TYPE_ID = 1
7384: GROUP BY cost_element_id;