54: FROM cm_scst_led
55: WHERE std_qty > 0
56: AND rownum < 2
57: AND cmpntcost_id in (SELECT cmpntcost_id
58: FROM cm_cmpt_dtl
59: WHERE inventory_item_id = p_prod_invy_item_id
60: AND period_id = p_period_id
61: AND cost_type_id = p_cost_type_id
62: AND organization_id = p_organization_id
67: FROM cm_scst_led
68: WHERE inventory_item_id = p_invy_item_id
69: AND rownum < 2
70: AND (line_type = -1 OR line_type = 2)
71: AND cmpntcost_id in (select cmpntcost_id from cm_cmpt_dtl
72: WHERE inventory_item_id = p_prod_invy_item_id
73: AND period_id = p_period_id
74: AND cost_type_id = p_cost_type_id
75: AND organization_id = p_organization_id