APPS.CSTPLVCP dependencies on CST_ITEM_COST_DETAILS

Line 1362: from cst_item_cost_details

1358: l_count := 0;
1359:
1360: select count(*)
1361: into l_count
1362: from cst_item_cost_details
1363: where /* organization_id = l_std_org : bugfix 3048258 */
1364: organization_id = l_std_cost_org
1365: and cost_type_id = 1
1366: and inventory_item_id = i_item_id;

Line 1418: from cst_item_cost_details cicd

1414: NULL,
1415: 'N',
1416: 0,
1417: 'N'
1418: from cst_item_cost_details cicd
1419: where /* organization_id = l_std_org : bugfix 3048258 */
1420: organization_id = l_std_cost_org
1421: and cost_type_id = 1
1422: and inventory_item_id = i_item_id

Line 1535: from cst_item_cost_details cicd

1531: i_prg_id,
1532: sysdate,
1533: cicd.item_cost,
1534: 'N'
1535: from cst_item_cost_details cicd
1536: where inventory_item_id = i_item_id
1537: and /* organization_id = l_std_org : bugfix 3048258 */
1538: organization_id = l_std_cost_org
1539: and cost_type_id = 1

Line 2489: from cst_item_cost_details cicd

2485: sum(item_cost)*i_conv_rate/i_um_rate,
2486: 0,
2487: 0,
2488: 0
2489: from cst_item_cost_details cicd
2490: where cicd.cost_type_id = i_cost_type_id
2491: and cicd.inventory_item_id = i_item_id
2492: /* and cicd.organization_id = i_from_org : bugfix 3048258 */
2493: and cicd.organization_id = l_from_cost_org