APPS.CSTPLVCP dependencies on CST_ITEM_COST_DETAILS

Line 1428: from cst_item_cost_details

1424: l_count := 0;
1425:
1426: select count(*)
1427: into l_count
1428: from cst_item_cost_details
1429: where /* organization_id = l_std_org : bugfix 3048258 */
1430: organization_id = l_std_cost_org
1431: and cost_type_id = 1
1432: and inventory_item_id = i_item_id;

Line 1484: from cst_item_cost_details cicd

1480: NULL,
1481: 'N',
1482: 0,
1483: 'N'
1484: from cst_item_cost_details cicd
1485: where /* organization_id = l_std_org : bugfix 3048258 */
1486: organization_id = l_std_cost_org
1487: and cost_type_id = 1
1488: and inventory_item_id = i_item_id

Line 1601: from cst_item_cost_details cicd

1597: i_prg_id,
1598: sysdate,
1599: cicd.item_cost,
1600: 'N'
1601: from cst_item_cost_details cicd
1602: where inventory_item_id = i_item_id
1603: and /* organization_id = l_std_org : bugfix 3048258 */
1604: organization_id = l_std_cost_org
1605: and cost_type_id = 1

Line 2555: from cst_item_cost_details cicd

2551: sum(item_cost)*i_conv_rate/i_um_rate,
2552: 0,
2553: 0,
2554: 0
2555: from cst_item_cost_details cicd
2556: where cicd.cost_type_id = i_cost_type_id
2557: and cicd.inventory_item_id = i_item_id
2558: /* and cicd.organization_id = i_from_org : bugfix 3048258 */
2559: and cicd.organization_id = l_from_cost_org