APPS.CSTPSCCM dependencies on CST_ITEM_COSTS

Line 41: FROM cst_item_costs cic

37: l_dest_cost_type_id NUMBER,
38: l_inventory_item_id NUMBER,
39: l_dest_organization_id NUMBER) IS
40: SELECT cic.inventory_item_id
41: FROM cst_item_costs cic
42: WHERE cic.inventory_item_id = l_inventory_item_id
43: AND cic.organization_id = l_dest_organization_id
44: AND cic.cost_type_id = l_dest_cost_type_id
45: /* Bug 2077929 - When no costs are defined for l_dest_cost_type_id,

Line 477: FROM CST_ITEM_COSTS CIA3

473: (
474: CICD2.cost_type_id = default_buy_cost_type_id
475: AND NOT EXISTS (
476: SELECT 'X'
477: FROM CST_ITEM_COSTS CIA3
478: WHERE CIA3.inventory_item_id = p_inventory_item_id
479: AND CIA3.organization_id = p_dest_organization_id
480: AND CIA3.cost_type_id = p_buy_cost_type_id)
481: )

Line 487: FROM CST_ITEM_COSTS CIA4

483: (
484: CICD2.cost_type_id = MP.primary_cost_method
485: AND NOT EXISTS (
486: SELECT 'X'
487: FROM CST_ITEM_COSTS CIA4
488: WHERE CIA4.inventory_item_id = p_inventory_item_id
489: AND CIA4.organization_id = p_dest_organization_id
490: AND CIA4.cost_type_id in (p_buy_cost_type_id,default_buy_cost_type_id))
491: )

Line 622: FROM CST_ITEM_COSTS CIA3

618: (
619: CICD2.cost_type_id = default_cost_type_id
620: AND NOT EXISTS (
621: SELECT 'X'
622: FROM CST_ITEM_COSTS CIA3
623: WHERE CIA3.inventory_item_id = p_inventory_item_id
624: AND CIA3.organization_id = src_org.source_organization_id
625: AND CIA3.cost_type_id = p_dest_cost_type_id)
626: )

Line 632: FROM CST_ITEM_COSTS CIA4

628: (
629: CICD2.cost_type_id = MP.primary_cost_method
630: AND NOT EXISTS (
631: SELECT 'X'
632: FROM CST_ITEM_COSTS CIA4
633: WHERE CIA4.inventory_item_id = p_inventory_item_id
634: AND CIA4.organization_id = src_org.source_organization_id
635: AND CIA4.cost_type_id in (p_dest_cost_type_id,default_cost_type_id))
636: )