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 1005: AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;

1001: CURSOR CUR_BILLING_TYPE(p_item_id NUMBER) IS
1002: SELECT material_billable_flag
1003: FROM mtl_system_items_b
1004: WHERE inventory_item_id = p_item_id
1005: AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;
1006:
1007: -- Cursor to get the item cost for a material item
1008: -- Service validation org is considered here.
1009: CURSOR CUR_MATERIAL_COST(p_item_id NUMBER) IS

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

1011: FROM cst_item_costs a, cst_cost_types b
1012: WHERE a.cost_type_id = b.cost_type_id
1013: AND UPPER(b.cost_type) = 'FROZEN'
1014: AND a.inventory_item_id = p_item_id
1015: AND a.organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;
1016:
1017: -- Cursor to get the txn_billing_Types from the repair type.
1018: CURSOR CUR_TXN_BILLING_TYPE(p_repair_type_id NUMBER, p_billing_category VARCHAR2, p_billing_type VARCHAR2) IS
1019: SELECT txn_billing_type_id

Line 1139: p_organization_id => Cs_Std.GET_ITEM_VALDN_ORGZN_ID,

1135: Csd_Cost_Analysis_Pvt.Get_ResItemCost(x_return_status => l_return_status,
1136: x_msg_count => l_msg_count,
1137: x_msg_data => l_msg_data,
1138: p_inventory_item_id => px_estimate_line_rec.inventory_item_id,
1139: p_organization_id => Cs_Std.GET_ITEM_VALDN_ORGZN_ID,
1140: p_bom_resource_id => null,
1141: p_charge_date => SYSDATE,
1142: p_currency_code => px_estimate_line_rec.currency_code,
1143: p_chg_line_uom_code => px_estimate_line_rec.unit_of_measure_code,

Line 1288: AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;

1284: primary_uom_code,
1285: material_billable_flag
1286: FROM mtl_system_items_b
1287: WHERE inventory_item_id = p_item_id
1288: AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;
1289:
1290:
1291: l_revision_control VARCHAR2(1);
1292: l_serial_control VARCHAR2(1);

Line 1342: Cs_Std.GET_ITEM_VALDN_ORGZN_ID)) THEN

1338: IF (p_estimate_line_rec.item_revision IS NOT NULL AND
1339: p_estimate_line_rec.item_revision <> Fnd_Api.G_MISS_CHAR AND
1340: NOT VALIDATE_REVISION(p_estimate_line_rec.item_revision,
1341: p_estimate_line_rec.inventory_item_id,
1342: Cs_Std.GET_ITEM_VALDN_ORGZN_ID)) THEN
1343: debug('Invalid revision[' || p_estimate_line_rec.item_revision || ']');
1344: RAISE Fnd_Api.G_EXC_ERROR;
1345: END IF;
1346: END IF;