APPS.CSD_LOGISTICS_UTIL dependencies on CS_STD

Line 349: AND b.organization_id = Cs_Std.get_item_valdn_orgzn_id

345: AND b.serv_req_enabled_code = 'E'
346: AND TRUNC(SYSDATE) BETWEEN
347: TRUNC(NVL(b.start_date_active, SYSDATE)) AND
348: TRUNC(NVL(b.end_date_active, SYSDATE))
349: AND b.organization_id = Cs_Std.get_item_valdn_orgzn_id
350: AND (cip.party_id = NVL(ip.internal_party_id, a.owner_party_id) OR
351: (cip.party_id = NVL(p_Party_ID, a.owner_party_id) AND
352: a.owner_party_account_id =
353: NVL(p_Account_id, a.owner_party_account_id)))

Line 398: AND Organization_Id = Cs_Std.get_item_valdn_orgzn_id

394: SELECT Lot_Number
395: INTO l_lot_number
396: FROM MTL_LOT_NUMBERS
397: WHERE Inventory_Item_Id = p_inventory_item_id
398: AND Organization_Id = Cs_Std.get_item_valdn_orgzn_id
399: AND Lot_Number = p_Lot_Number;
400:
401: EXCEPTION
402:

Line 449: -- AND current_organization_id = cs_std.get_item_valdn_orgzn_id

445: INTO l_Current_Status
446: FROM mtl_serial_numbers
447: WHERE inventory_item_id = p_inventory_item_id
448: -- SU Should not check for current organization
449: -- AND current_organization_id = cs_std.get_item_valdn_orgzn_id
450: AND serial_number = p_Serial_Number;
451:
452: IF l_Current_Status NOT IN
453: (C_STATUS_OUT_OF_STORES, C_STATUS_INTRANSIT)

Line 562: AND organization_id = Cs_Std.get_item_valdn_orgzn_id

558: SELECT Unit_of_measure
559: INTO l_Unit_Of_Measure
560: FROM mtl_item_uoms_view
561: WHERE inventory_item_id = p_inventory_item_id
562: AND organization_id = Cs_Std.get_item_valdn_orgzn_id
563: AND UOM_Code = p_Unit_Of_Measure
564: AND uom_type =
565: (SELECT allowed_units_lookup_code
566: FROM mtl_system_items_b

Line 567: WHERE organization_id = Cs_Std.get_item_valdn_orgzn_id

563: AND UOM_Code = p_Unit_Of_Measure
564: AND uom_type =
565: (SELECT allowed_units_lookup_code
566: FROM mtl_system_items_b
567: WHERE organization_id = Cs_Std.get_item_valdn_orgzn_id
568: AND inventory_item_id = p_inventory_item_id);
569:
570: EXCEPTION
571:

Line 1048: --AND current_organization_id = cs_std.get_item_valdn_orgzn_id

1044: FROM mtl_serial_numbers
1045: WHERE inventory_item_id = p_inventory_item_id
1046: -- SU:02/24: While doing Serial Number validation current organization should not be
1047: -- hard coded to item validation organization. So please comment following statement
1048: --AND current_organization_id = cs_std.get_item_valdn_orgzn_id
1049: AND serial_number = p_Serial_Number;
1050:
1051: IF l_Current_Status <> (C_Status_In_Stores)
1052: THEN

Line 1211: p_inv_org_id => Cs_Std.get_item_valdn_orgzn_id,

1207: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1208:
1209: -- Get Item attributes in local variable
1210: Get_ItemAttributes(p_Inventory_Item_Id => p_Product_Txn_Rec.Inventory_Item_Id,
1211: p_inv_org_id => Cs_Std.get_item_valdn_orgzn_id,
1212: x_ItemAttributes => l_ItemAttributes);
1213:
1214: -- Open RO_Cur_Type AND fetch values into local variables.
1215: OPEN RO_Cur_Type(p_Product_Txn_Rec.Repair_line_Id);

Line 2088: x_order_rec.org_id := Cs_Std.get_item_valdn_orgzn_id;

2084: END IF;
2085:
2086: -- assigning values for the order record
2087: x_order_rec.incident_id := l_incident_id;
2088: x_order_rec.org_id := Cs_Std.get_item_valdn_orgzn_id;
2089:
2090: RETURN x_order_rec;
2091:
2092:

Line 2729: Cs_Std.get_item_valdn_orgzn_id

2725: SELECT revision_qty_control_code
2726: INTO l_rev_ctl_code
2727: FROM mtl_system_items
2728: WHERE organization_id =
2729: Cs_Std.get_item_valdn_orgzn_id
2730: AND inventory_item_id =
2731: p_product_txn_rec.inventory_item_id;
2732: EXCEPTION
2733: WHEN NO_DATA_FOUND THEN

Line 2749: Cs_Std.get_item_valdn_orgzn_id

2745: FROM mtl_item_revisions
2746: WHERE inventory_item_id =
2747: p_product_txn_rec.inventory_item_id
2748: AND organization_id =
2749: Cs_Std.get_item_valdn_orgzn_id
2750: AND revision = p_product_txn_rec.revision;
2751: EXCEPTION
2752: WHEN NO_DATA_FOUND THEN
2753: Fnd_Message.SET_NAME('CSD',