APPS.CTO_CONFIG_ITEM_PK dependencies on CST_ITEM_COST_DETAILS

Line 6376: cst_item_cost_details CICD,

6372: l_rt_cicd_summary.overhead_cost
6373: from
6374: mtl_parameters MP1,
6375: cst_item_costs C,
6376: cst_item_cost_details CICD,
6377: mtl_system_items S -- 4172300
6378: where S.organization_id = C.organization_id
6379: and S.inventory_item_id = C.inventory_item_id
6380: and C.organization_id = MP1.organization_id

Line 6837: Insert rows into the cst_item_cost_details table

6833:
6834:
6835:
6836: /*------ ----------------------------------------------+
6837: Insert rows into the cst_item_cost_details table
6838: +-----------------------------------------------------*/
6839:
6840: lStmtNumber := 230;
6841:

Line 6842: insert into cst_item_cost_details

6838: +-----------------------------------------------------*/
6839:
6840: lStmtNumber := 230;
6841:
6842: insert into cst_item_cost_details
6843: (inventory_item_id,
6844: cost_type_id,
6845: last_update_date,
6846: last_updated_by,

Line 6933: cst_item_cost_details C,

6929: C.attribute14,
6930: C.attribute15
6931: from
6932: mtl_parameters MP1,
6933: cst_item_cost_details C,
6934: mtl_system_items S,
6935: bom_cto_src_orgs bcso
6936: where S.organization_id = C.organization_id
6937: and S.inventory_item_id = C.inventory_item_id

Line 6948: from cst_item_cost_details

6944: and C.COST_TYPE_ID IN ( MP1.primary_cost_method, MP1.avg_rates_cost_type_id)
6945: and mp1.organization_id = bcso.organization_id
6946: and NOT EXISTS
6947: (select NULL
6948: from cst_item_cost_details
6949: where inventory_item_id = pConfigId
6950: and organization_id = mp1.organization_id
6951: and COST_TYPE_ID IN (MP1.primary_cost_method, MP1.avg_rates_cost_type_id));
6952:

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

6952:
6953:
6954:
6955: IF PG_DEBUG <> 0 THEN
6956: oe_debug_pub.add('Create_Item: ' || 'after insert:cst_item_cost_details inserted '||to_char(sql%rowcount),2);
6957: END IF;
6958:
6959:
6960:

Line 6966: insert into cst_item_cost_details

6962:
6963: /* For standard costing orgs, we will copy model's user-defined
6964: cost in Frozen to the config in CTO cost type. */
6965:
6966: insert into cst_item_cost_details
6967: (inventory_item_id,
6968: cost_type_id,
6969: last_update_date,
6970: last_updated_by,

Line 7057: cst_item_cost_details C,

7053: C.attribute14,
7054: C.attribute15
7055: from
7056: mtl_parameters MP1,
7057: cst_item_cost_details C,
7058: mtl_system_items S,
7059: bom_cto_src_orgs bcso
7060: where S.organization_id = C.organization_id
7061: and S.inventory_item_id = C.inventory_item_id

Line 7073: from cst_item_cost_details

7069: and C.cost_type_id = 1
7070: and mp1.organization_id = bcso.organization_id
7071: and NOT EXISTS
7072: (select NULL
7073: from cst_item_cost_details
7074: where inventory_item_id = pConfigId
7075: and organization_id = mp1.organization_id
7076: and COST_TYPE_ID = l_cto_cost_type_id);
7077:

Line 7162: FROM cst_item_cost_details

7158: -1,
7159: -1,
7160: SYSDATE,
7161: NVL(SUM(item_cost),0)
7162: FROM cst_item_cost_details
7163: WHERE ORGANIZATION_ID = v_organization_id
7164: AND INVENTORY_ITEM_ID = pConfigId
7165: AND COST_TYPE_ID = 1;
7166:

Line 7195: FROM cst_item_cost_details

7191: SYSDATE,
7192: -1,
7193: -1,
7194: NVL(SUM(item_cost),0)
7195: FROM cst_item_cost_details
7196: WHERE ORGANIZATION_ID = v_organization_id
7197: AND INVENTORY_ITEM_ID = pConfigId
7198: AND COST_TYPE_ID = 1
7199: GROUP BY cost_element_id;