APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_PARAMETERS

Line 721: FROM mtl_parameters

717: SELECT serial_number_type, -- serial number uniqueness control
718: default_cost_group_id
719: INTO l_serial_type,
720: l_cst_grp_id
721: FROM mtl_parameters
722: WHERE organization_id = p_inv_org_id;
723: EXCEPTION
724: WHEN no_data_found THEN
725: l_return_value := FALSE;

Line 954: mtl_parameters p

950: BEGIN
951: SELECT 'x'
952: INTO l_temp
953: FROM mtl_serial_numbers s,
954: mtl_parameters p
955: WHERE s.current_organization_id = p.organization_id
956: AND s.serial_number = p_serial_number
957: AND p.serial_number_type = 3
958: AND ROWNUM = 1;

Line 1264: FROM mtl_parameters

1260: l_return_value := TRUE;
1261: BEGIN
1262: SELECT serial_number_type -- serial number uniqueness control
1263: INTO l_serial_type
1264: FROM mtl_parameters
1265: WHERE organization_id = p_inv_org_id;
1266: EXCEPTION
1267: WHEN no_data_found THEN
1268: l_return_value := FALSE;

Line 1399: mtl_parameters p

1395: BEGIN
1396: SELECT 'x'
1397: INTO l_temp
1398: FROM mtl_serial_numbers s,
1399: mtl_parameters p
1400: WHERE s.current_organization_id = p.organization_id
1401: AND s.serial_number = p_serial_number
1402: AND p.serial_number_type = 3
1403: AND ROWNUM = 1;

Line 1519: FROM mtl_parameters

1515: -- Get the lot uniqueness type for the transacting organization
1516: BEGIN
1517: SELECT lot_number_uniqueness -- lot number uniqueness control
1518: INTO l_lot_type
1519: FROM mtl_parameters
1520: WHERE organization_id = p_inv_org_id;
1521: EXCEPTION
1522: WHEN NO_DATA_FOUND THEN
1523: l_return_value := FALSE;

Line 1749: FROM mtl_parameters

1745: l_drive_qty NUMBER := 0;
1746:
1747: Cursor c1 is
1748: SELECT negative_inv_receipt_code
1749: FROM mtl_parameters
1750: WHERE organization_id = p_inv_organization_id;
1751:
1752: BEGIN
1753:

Line 3508: FROM mtl_parameters

3504: l_return_value BOOLEAN := TRUE;
3505:
3506: Cursor c1 is
3507: SELECT negative_inv_receipt_code
3508: FROM mtl_parameters
3509: WHERE organization_id = p_inv_organization_id;
3510: BEGIN
3511: -- IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN
3512: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized

Line 5328: from MTL_PARAMETERS

5324: --
5325: Begin
5326: select 'x'
5327: into l_exists
5328: from MTL_PARAMETERS
5329: where organization_id = p_master_org_id
5330: and master_organization_id = p_master_org_id;
5331: l_return_value := TRUE;
5332: Exception