APPS.CSD_ESTIMATE_UTILS_PVT dependencies on CS_STD

Line 188: AND organization_id = Cs_Std.get_item_valdn_orgzn_id

184: CURSOR c1 IS
185: SELECT 1 col1
186: FROM mtl_item_uoms_view
187: WHERE inventory_item_id = p_item_id
188: AND organization_id = Cs_Std.get_item_valdn_orgzn_id
189: AND uom_type =
190: (SELECT allowed_units_lookup_code
191: FROM mtl_system_items_b
192: WHERE organization_id = Cs_Std.get_item_valdn_orgzn_id

Line 192: WHERE organization_id = Cs_Std.get_item_valdn_orgzn_id

188: AND organization_id = Cs_Std.get_item_valdn_orgzn_id
189: AND uom_type =
190: (SELECT allowed_units_lookup_code
191: FROM mtl_system_items_b
192: WHERE organization_id = Cs_Std.get_item_valdn_orgzn_id
193: AND inventory_item_id = p_item_id)
194: AND uom_code = p_uom_code;
195: l_tmp_count NUMBER;
196: BEGIN

Line 980: AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;

976: CURSOR CUR_BILLING_TYPE(p_item_id NUMBER) IS
977: SELECT material_billable_flag
978: FROM mtl_system_items_b
979: WHERE inventory_item_id = p_item_id
980: AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;
981:
982: -- Cursor to get the item cost for a material item
983: -- Service validation org is considered here.
984: CURSOR CUR_MATERIAL_COST(p_item_id NUMBER) IS

Line 990: AND a.organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;

986: FROM cst_item_costs a, cst_cost_types b
987: WHERE a.cost_type_id = b.cost_type_id
988: AND UPPER(b.cost_type) = 'FROZEN'
989: AND a.inventory_item_id = p_item_id
990: AND a.organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;
991:
992: -- Cursor to get the txn_billing_Types from the repair type.
993: CURSOR CUR_TXN_BILLING_TYPE(p_repair_type_id NUMBER, p_billing_category VARCHAR2, p_billing_type VARCHAR2) IS
994: SELECT txn_billing_type_id

Line 1114: p_organization_id => Cs_Std.GET_ITEM_VALDN_ORGZN_ID,

1110: Csd_Cost_Analysis_Pvt.Get_ResItemCost(x_return_status => l_return_status,
1111: x_msg_count => l_msg_count,
1112: x_msg_data => l_msg_data,
1113: p_inventory_item_id => px_estimate_line_rec.inventory_item_id,
1114: p_organization_id => Cs_Std.GET_ITEM_VALDN_ORGZN_ID,
1115: p_bom_resource_id => null,
1116: p_charge_date => SYSDATE,
1117: p_currency_code => px_estimate_line_rec.currency_code,
1118: p_chg_line_uom_code => px_estimate_line_rec.unit_of_measure_code,

Line 1263: AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;

1259: primary_uom_code,
1260: material_billable_flag
1261: FROM mtl_system_items_b
1262: WHERE inventory_item_id = p_item_id
1263: AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;
1264:
1265:
1266: l_revision_control VARCHAR2(1);
1267: l_serial_control VARCHAR2(1);

Line 1317: Cs_Std.GET_ITEM_VALDN_ORGZN_ID)) THEN

1313: IF (p_estimate_line_rec.item_revision IS NOT NULL AND
1314: p_estimate_line_rec.item_revision <> Fnd_Api.G_MISS_CHAR AND
1315: NOT VALIDATE_REVISION(p_estimate_line_rec.item_revision,
1316: p_estimate_line_rec.inventory_item_id,
1317: Cs_Std.GET_ITEM_VALDN_ORGZN_ID)) THEN
1318: debug('Invalid revision[' || p_estimate_line_rec.item_revision || ']');
1319: RAISE Fnd_Api.G_EXC_ERROR;
1320: END IF;
1321: END IF;